Searching a table on different combinations of columns

Anvil Q&A
3

Thanks for your response - I have tried the example in the Anvil Docs:

kwargs = {'age': 42, 'employed': True}
filtered_table = app_tables.people.search(**kwargs)

This works as the fields are numeric and True/False which uses equals (=)

I need to search on text fields with q.like for partial and whole words e.g. ‘%’ + Name +‘%’. Any suggestions would be welcome.

1 Like