Filter

• where: Filters the query results based on the specified conditions

String Operators

• contains: Returns true if the string contains a specified substring, ignoring case
• startsWith: Returns true if the string starts with a specified substring, ignoring case
• endsWith: Returns true if the string ends with a specified substring, ignoring case
• ncontains: Returns true if the string does not contain a specified substring, ignoring case
• nstartsWith: Returns true if the string does not start with a specified substring, ignoring case
• nendsWith: Returns true if the string does not end with a specified substring, ignoring case
• in: In
• nin: Not in

Comparable Operators

• eq: Equals
• neq: Not equals
• in: In
• nin: Not in
• gt: Greater than
• lt: Less than
• gte: Greater than or equal
• lte: Less than or equal

Logical Operators

• and: Returns true if both conditions are true
• or: Returns true if either condition is true

Collection Operators

• all: Returns true if the condition is true for all items in the collection
• none: Returns true if the condition is false for all items in the collection
• some: Returns true if the condition is true for some items in the collection

Sorting

• orderBy: Specifies the field(s) to sort the results by
• asc: Sorts the results in ascending order
• desc: Sorts the results in descending order

Pagination

• first: Specifies the maximum number of first items to return
• last: Specifies the maximum number of last items to return
• after: Specifies the end cursor of the previous page of items
• before: Specifies the start cursor of the next page of items
• cursor: A unique identifier for the current item in the query result
• pageInfo
  • startCursor: The cursor of the first item in the result set
  • endCursor: The cursor of the last item in the result set
  • hasNextPage: Indicates whether there is a next page of items
  • hasPreviousPage: Indicates whether there is a previous page of items

Hot Chocolate documentation

Below are links to the pages describing the Hot Chocolate filters :

• Hot Chocolate filters documentation
• and & or
• boolean filter
• comparable filter
• string filter
• enum filter
• object filter
• list filter