[Answered ]-Retrieving OneToOne related QuerySet in Django

by

2👍

As stated by kathikr, the following nested query can be used to retrieve the SharedBookmarks that are OneToOne related to the QuerySet of Bookmarks returned.

SharedBookmark.objects.filter(bookmark__in=Bookmark.objects.search(query))

But when using this query with djorm-ext-pgfulltext, it produces an “invalid reference to FROM-clause entry for table…” error. According to https://groups.google.com/d/topic/django-users/5PrcxbF38Ag/discussion this is most likely caused by djorm-ext-pgfulltext not supporting alias relabeling – specifically the use of extra() in the search method defined in djorm-ext-pgfulltext. The following statement will force two separate queries that will avoid the error:

SharedBookmark.objects.filter(bookmark__in=list(Bookmark.objects.search(query)))
👤Derek

Leave a comment