How would I do the following query:
OrderNotes.objects.filter(item=item).distinct('shared_note')
Basically, I need to get all OrderNotes items, distinct on shared_note. When I try and do this I get:
raise NotImplementedError('DISTINCT ON fields is not supported by this database backend')
NotImplementedError: DISTINCT ON fields is not supported by this database backend
I am using mysql and cannot change the db here. What would be the workaround in django?