You are currently viewing the new Anvil Editor Docs.
Switch to the Classic Editor Docs
You are currently viewing the Classic Editor Docs.
Switch to the new Anvil Editor Docs

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.


                            anvil.tables.query