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.
fetch_only(*only_cols, **linked_cols)
(more info)
Control which columns are loaded from a table search to speed up queries by only fetching the data you need.
only_cols
- Column names to fetch from the table. Example: fetch_only('email', group=q.fetch_only('name'))linked_cols
- Linked columns to fetch, specified as keyword arguments. Each value must be another fetch_only() object.
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
only_cols(*cols)
(more info)
Control which columns are accessible from a view, restricting access to specific columns.
cols
- Column names to make accessible in the view. Example: only_cols('email', 'enabled')
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.