tityrus
commented
7 years ago If you work your way through the code of Jet, you can make some overrides yourself. However, it would be good to see support included.
I propose this code as a replacement for the jet/forms.py lookup function:
`
def lookup(self):
if self.cleaned_data['q']:
if getattr(self.model_cls, 'autocomplete_search_fields') and getattr(self.model_cls, 'autocomplete_search_query'):
raise Exception("The model cannot have both an autocomplete_search_fields and autocomplete_search_query function.")
elif getattr(self.model_cls, 'autocomplete_search_query'):
qs = self.model_cls.autocomplete_search_query(self.cleaned_data['q'])
elif getattr(self.model_cls, 'autocomplete_search_fields'):
qs = self.model_cls.objects
search_fields = self.model_cls.autocomplete_search_fields()
filter_data = [Q((field + '__icontains', self.cleaned_data['q'])) for field in search_fields]
qs = qs.filter(reduce(operator.or_, filter_data))
else:
qs = self.model_cls.objects.none()
limit = self.cleaned_data['page_size'] or 100
page = self.cleaned_data['page'] or 1
offset = (page - 1) * limit
items = list(map(lambda instance: {
'id': instance.pk,
'text': get_model_instance_label(instance)
}, qs.all()[offset:offset + limit]))
total = qs.count()
return items, total` This way you could define a autocomplete_search_query function in your models.
jackboot7
tolomea
SalahAdDin
Ismael-VC
abdulwahid24
gotounix
In docs, its mentioned that -
Then how to deal with large tables, with custom queryset. How are you handling this issue ? Is there any workaround for this ?
Edit: I tried to use django autocomplete light for autocompletion with custom queryset. But it's showing two select dropdown widgets.
How can I fix these widgets ?