Metadata: Created on October 2024, Product: PAC Classic
Understanding and utilizing common query operators can significantly enhance your data analysis and query searches. Below, we'll explore step-by-step examples of how to effectively use these operators:
$ - Contains
This operator enables searching fields where you know a specific word or value is contained within the data. For instance, to find all PAC Organizations with "Freedom" in the name, use $Freedom in the search box for PAC Org. This can be applied to text, pick lists, or text-validated fields.
< - Less Than
Useful for numeric fields, this operator identifies values less than the specified number. For example, to find individuals with a UDF association number less than 50000, input <50000 in the search field.
> - Greater Than
Similar to the previous operator, this one identifies values greater than the specified number. For individuals with an Association ID greater than 50000, use >50000.
<= - Less Than or Equal To
Includes values equal to the specified number along with those less than it. To find individuals with an Association ID less than or equal to 50000, use <=50000.
>= - Greater Than or Equal To
Similar to the previous operator, but includes values equal to the specified number. For individuals with an Association ID greater than or equal to 50000, use >=50000.
<> - Not Equal To
Useful for comparing lists, this operator identifies records present in one list but not in another. For example, to find individuals in List A but not in List B, use <>.
+ - The And Operator
Identifies records present in both List A and List B. Use + instead of ; to denote this operation.
–EMPTY-
Helps identify missing information in records. For instance, to find individuals without an Association ID, use –EMPTY-.
<>-EMPTY-
Identifies records where certain fields are not empty. For example, to find legislators with associated notes, use <>-EMPTY- in the Notes field.
Utilizing these operators empowers you to conduct more refined and comprehensive searches within your database, ensuring accurate analysis and data management.