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
page_size(rows)
Define the number of rows that are fetched per round trip to the server.
Do you still have questions?
Our Community Forum is full of helpful information and Anvil experts.