This article is the end of a series. To start with an overview of the Query Tool, please click here to go to the beginning of the series.
When adding a filter, there is an operator to show the relationship between the filter field and the value: the filter field must equal the value, be less than the value, greater than the value, etc.
Breakdown of Operators
- Equals: For some fields, this operator will look at the value and if the field matches this value, it will be included in the results.
- Not Equal: For some fields, this operator will look at the value and if the field does NOT match this value, it will be included in the results.
- Greater Than: For some fields, this operator will look at the value and if the field is greater than this value, it will be included in the results.
- Less Than: For some fields, this operator will look at the value and if the field is less than this value, it will be included in the results.
- Contains: For some fields, this operator will look at the value and if the field contains this value, it will be included in the results.
- Does Not Contain: For some fields, this operator will look at the value and if the field does NOT contain this value, it will be included in the results.
- In the Period: For some fields, this operator will look at the value and if the field matches this value, it will be included in the results. This will only be available for filter fields that involve a date.
- Last 1 Day: The filter field will show profiles or records if the chosen date field has a value that falls on yesterday or today.
- Last 7 Days: The filter field will show profiles or records if the chosen date field has a value that falls on any day from 7 days ago through today.
- Last 30 Days: The filter field will show profiles or records if the chosen date field has a value that falls on any day from 30 days ago through today.
- Month To Date: The filter field will show profiles or records if the chosen date field has a value that falls on the first day of the month through the current date.
- Previous Month: The filter field will show profiles or records if the chosen date field has a value that falls on any day from the first day of last month to the last day of last month.
- Year To Date: The filter field will show profiles or records if the chosen date field has a value that falls on any day from the January 1 of this year through the current date.
- Previous Year: The filter field will show profiles or records if the chosen date field has a value that falls on any day from the January 1 of last year through December 31 of last year.
- Next 7 Days: The filter field will show profiles or records if the chosen date field has a value that falls on any day from today through 7 days later.
- Next 30 Days: The filter field will show profiles or records if the chosen date field has a value that falls on any day from today through 30 days later.
- Next 60 Days: The filter field will show profiles or records if the chosen date field has a value that falls on any day from today through 60 days later.
Multiple Filters
If you add more than one filter, notice that there is an AND/OR drop down between rows:
In the example above, the query should filter down to profiles that are members AND those profiles must be organizations.
If we want to add another filter that filters down to profiles in a specific county, we would use another AND, and if we want to add another filter for a different possible county, we would use OR:
For the example above, the query should filter down to profiles that are members, AND those profiles must be organizations, AND those profiles must be in Maricopa county, OR in Marion county.
There is a problem though:
- Profiles that are members...
- AND that are organizations...
- AND that are in Maricopa county...
- OR simply profiles that are in Marion county.
This would return profiles in Marion county whether they are members organizations or not.
For this to filter properly, you need to put the counties under the same filter group.
This adds parenthesis around them, so that they are grouped, and stick together:
- Profiles that are members...
- AND that are organizations...
- (AND that are in Maricopa county OR Marion county).
Any additional counties would need to be in the same group number to keep them all together.