# Querying & Filtering Data Rezonate has advanced query builder capabilities that allow filtering and sorting for all of the data that is being collected from different integrated platforms. This capability is supported across the entire product through the filters & search boxes that are placed above any table.

For example, if we are looking for all of the enabled user accounts with global admin directory roles who were active in the last week, we can write something like this:

\ The Query builder has many operators that can be used, below is a detailed list of them and their purpose:

### Text Operators

Operator	Purpose	Example
starts with	Search for any text that starts with a specific text. (Insensitive)	Find all users whose name starts with Or (Will result in Ori, Oran, etc..)
contains	Search for any text that contains a specific text (Insensitive)	Find all users whose name contains Or (Will result in Ori, Oran, Lior, etc..)
not contains	Search for any text that not contains a specific pattern	Find all users whose names do not contain ABC.
equals	Search for any equal text (case-sensitive) to a specific text	Find all users with a first name equal to Ori.
not equals	Search for any text that is not equal (case-sensitive) to a specific text	Find all users with first names not equal to Ori.

### Date Operators

Operator	Purpose	Example
last	Search for dates that occurred within the selected relative date.	Find all users whose last login was within* the last week.*
before-last	Search for dates that occurred before the selected relative date.	Find all users whose last login was before* the last week.*
before	Search for dates that occurred before the selected date	Find all users whose last login was before* 1/1/2024*
after	Search for dates that occurred after the selected date	Find all users whose last login was after* 1/1/2024*

{% hint style="success" %} Pro Tip! - When saving searches in the query catalog, its always preferred to use relative date operators such as last or before-last. {% endhint %} ### Boolean Operators

Operator	Purpose	Example
is	Find a matching value for the boolean	Find all users with enabled* account. (Enabled is true)*

### Number Operators

Operator	Purpose	Example
Bigger Than	Find records with a number bigger than the searched input	Find all users with age>10
Smaller Than	Find records with a number smaller than the searched input	Find all users with age<10
Equals	Find records with a number equal to a selected input	Find all users with age=10
Not Equals	Find records with a number not equal to a selected input	Find all users with age!=10

### Filters Combinations When combining **multiple filters** on the **same** **field**, the resulting query term would apply **AND** criteria between them. this means that when searching for Name contains "Ori" and Name contains "Levy" the compiled search would be ``` Name contains "Ori" AND Name contains "Levy" ``` #### Special Cases Although the regular behavior, when combining multiple **Equals** filters on the same field, Rezonate will compile them with **OR** Operator. this means that when searching for Name equals "Ori", and Name equals "Ron" the compiled search would be ``` Name equals "Ori" OR Name equals "Ron" ```