Query data tables with regex

Anvil Q&A
1

Is it possible to search with regular expressions?

I’m interested in searching a data table that has an unknown number of leading 0’s. In other words:

search_str = '123'
app_tables.SOME_TABLE.search(column1=q.regex(f"0*{search_str}"))
2

How about the like operator? See

Not guaranteed to match only zeroes. Depending on your data, though, it might weed out most of your mismatches.