custom lookup field in column defs

morlandi / django-ajax-datatable

A Django app which provides the integration of a Django project with the jQuery Javascript library DataTables.net

MIT License

204 stars 64 forks source link

custom lookup field in column defs #43

Closed klavman closed 2 years ago

klavman commented 2 years ago

column_defs = [
    { 'name': 'codclient', 'title':'Client ID', 'visible': True, 'lookup_field': '__exact' },
    { 'name': 'phone', 'title':'Mobile phone', 'visible': True, 'lookup_field': '__startswith' }
]

PostgreSQL specific lookups

column_defs = [
    'name': 'fullname', 'title':'Fullname', 'visible': True, 'lookup_field': '__unaccent__icontains'
]

works for text search, default lookup field is '__icontains'
don't work for dates or choices

morlandi commented 2 years ago

Thank you, @klavman I'll merge this soon ;)