When building a Query, you'll use statements that include a Virtuous field, an operator, and then a value that you want to use to identify specific records. For example, to find all Contacts in the state of North Dakota, you'll look for Contacts where "State --> Is --> ND." This particular Query statement uses the operator "Is."
The available operators will vary depending on the field selected. Most will include standard values like "Is" and "Not." The "Is Null" operator can be used to find any records where a specific value is blank.
When using dates in query criteria, specific calendar dates can be used when selecting these operators:
- Greater Than
- Greater Than or Equal To
- Less Than
- Less Than or Equal To
There are also two operators, "Before" and "After," that can be used to select relative dates, which are ideal for saved queries that will be run frequently. When using relative dates, the available timeframes are:
- Last Sunday
- Start of this Month
- 30 days Ago
- 60 Days Ago
- 90 Days Ago
- 180 Days Ago
- 270 Days Ago
- 365 Days Ago
- This Calendar Year
For some fields where there exists a one-to-many relationship, as with Contact tags, there are several available operators, but most queries only need one of the following two operators:
- Any Is - Use this to find any records that include the selected values. It's possible to select multiple values within the same field when using this operator.
- All Are Not - use this operator to exclude records that include the selected values. With this operator, only one value may be selected per row when building a Query.