Live Chat

We'll need to share your messages (and your email address if you're logged in) with our live chat provider, Drift. Here's their privacy policy.

If you don't want to do this, you can email us instead at contact@anvil.works.

anvil.tables.query Module

Functions

all_of(query_expressions)

Match all query parameters given as arguments and keyword arguments


any_of(query_expressions)

Match any query parameters given as arguments and keyword arguments


between(min, max, [min_inclusive=True], [max_inclusive=False])

Match values between the provided min and max, optionally inclusive.


full_text_match(query, [raw=False])

Match values that match the provided full-text search query.


greater_than(value)

Match values greater than the provided value.


greater_than_or_equal_to(value)

Match values greater than or equal to the provided value.


ilike(pattern)

Match values using a case-insensitive ILIKE query, using the % wildcard character.


less_than(value)

Match values less than the provided value.


less_than_or_equal_to(value)

Match values less than or equal to the provided value.


like(pattern)

Match values using a case-sensitive LIKE query, using the % wildcard character.


none_of(query_expressions)

Match none of the query parameters given as arguments and keyword arguments


not_(query_expressions)

Match none of the query parameters given as arguments and keyword arguments



anvil.tables.query