Live demo

ID headline pub date


Description

When a user searches a datatable, the server will query all of the concrete fields in the displayed columns. You can enable extra search fields that are not shown on the table, but are consulted during a search query, by adding datatable_options["search_fields"].

search_fields is a simple list of fields using the normal query language. In this case, "blog__name" has been added to the list of fields, and so you can search the above table for the term First or Second and see the table filter the results, even though that field is not included as a real column.



Implementation in code

        
    class SearchFieldsDatatableView(DatatableView):
        model = Entry
        datatable_options = {
            'columns': [
                'id',
                'headline',
                'pub_date',
            ],
            'search_fields': ['blog__name'],
        }