.png?sv=2022-11-02&spr=https&st=2024-11-21T13%3A13%3A38Z&se=2024-11-21T13%3A23%3A38Z&sr=c&sp=r&sig=mOgpYVYuXJqFw2Qx1TWD8qfRtgfwkKhUluxH6vzm7Jw%3D){kind=logo}
The Operators: Tips 7-8
- 04 Mar 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
The Operators: Tips 7-8
- Updated on 04 Mar 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The First 6 Operators:
FYI about Filters:
Filters are NOT case sensitive (Caps and Lowercase are interchangeable and do NOT need to be exact matches for filter to work).
Filter Tip #7:
Use the Operators to change the meaning of your filter:
- The operators are located between the Field and Where on the bottom of the filter. Right click or type over to access them.
What do the first 6 Operators mean:
= means equals to, the field must match exactly
< means less than, the field is less then the value in the Where box
<= means less than or equal to, the field is less than the value or the value itself
> means more than, the field is more than the value in the Where box
>= means more than or equal to, the field is more than or equal to the value itself
<> means less than or more than but NOT equal to (in short it means NOT)
< means less than, the field is less then the value in the Where box
<= means less than or equal to, the field is less than the value or the value itself
> means more than, the field is more than the value in the Where box
>= means more than or equal to, the field is more than or equal to the value itself
<> means less than or more than but NOT equal to (in short it means NOT)
Helpful Trick:
< looks like an L for Less than
Remember! When entering dates:
> means from this date and onward, >= will INCLUDE the chosen date
< means until this date and no further, <= will INCLUDE the chosen date
< means until this date and no further, <= will INCLUDE the chosen date
How does <> Differ from "Does NOT have"?
- Does NOT have:
- Cannot have any criteria equalling it to be included
- Even if it has none of the criteria it will still pull
- <>:
- Can be included if have some criteria that equal as long as there is one that does not equal.
- Needs to have at least one match Example: Field Section: Accounts, Entity: Pledges
A. Do NOT have Pledges Amount = 500 VS B. Have Pledges Amount <> 5001. In A: it cannot have even 1 pledge for $500 to pull VS In B: will be included if there is 1 pledge on that account that is NOT $500
2. In A: if the account has NO pledges at all it will pull VS In B: the account needs to have at least 1 pledge to pull
FYI: Account List with Pledges VS Pledge List:
- Account List with Pledges = a list of accounts, pledges are secondary
- Pledge List = list of pledges
The Last 2 Operators:
Filter Tip #8:
The Operators "Like" and "Not Like" act as Smart Searches:
FYI: Smart Searches in Admire:
- Available in various screens
- Allows you to find things you need in a quick manner
- Might not work if you do not know correct spelling
- Adrenaline Smart Search is even SMARTER!!
- Like, as an Operative on a Filter:
- Allows you to smart search on the filter
Allows you to find the data without putting in the full string of characters
Using the % to Broaden Your Smart Search:
The % stands for "Anything" or "Nothing" meaning anything or nothing can be in that place.
Similar concept to a Joker/Wild card.
This will pull any Term that ends with 23-24, i.e. Boys 23-24, Girls 23-24 and Preschool 23-24
Similar concept to a Joker/Wild card.
Example:
A.
This will pull for any Occasion which has the word Dinner in it i.e. Dinner '23, 4th Annual Dinner or Special Dinner 2022-2023
This will pull any Term that ends with 23-24, i.e. Boys 23-24, Girls 23-24 and Preschool 23-24- Not Like, as an Operative on a Filter:
- Works the same as "Like" with a different meaning.
- Means: "Does Not Include"
- You can use the % sign here as well.
When using "Do Not Have" in addition to "Not Like":
If you use "Not Like" in a filter together with "do not have":
Then you have 2 negatives in your filter which makes things confusing.
Here's the deal: The filter is now saying that the only thing you could have is what is written in the criterion, i.e., you may have NOTHING, but IF you have ANYTHING, then what is written in the criterion is the ONLY thing you can possibly have.
Example: In the screenshot above, the filter would be saying "Only pull a record if it does not have a current registration or if it has a current registration in the Term Boys 23-24... NOTHING ELSE."
Then you have 2 negatives in your filter which makes things confusing.Here's the deal: The filter is now saying that the only thing you could have is what is written in the criterion, i.e., you may have NOTHING, but IF you have ANYTHING, then what is written in the criterion is the ONLY thing you can possibly have.
Example: In the screenshot above, the filter would be saying "Only pull a record if it does not have a current registration or if it has a current registration in the Term Boys 23-24... NOTHING ELSE."
FYI:
When marking a filter with "is null" (meaning "it does not have this value") the filter ignores the operator.
Example: In these two filters the results will be the same since the < & > signs are being ignored:
Example: In these two filters the results will be the same since the < & > signs are being ignored:
Was this article helpful?