Resources

Filter Operators

When adding filters for reports or list views, operators and parameters are important to determine what type of data is desired.


The following operators are available within Snapforce:



Equals: Every value exactly like the one you enter.

Not equal to: Every value except the one you enter.

Contains: Everything containing the value you enter.

Does not contain: Everything that does not contain the value you enter.

Less than: Everything less than the value you enter.

Greater than: Everything greater than the value you enter.

Less or equal: Everything less than or equal to the value you enter.

Greater or equal: Everything greater than or equal to the value you enter.

In: You will enter a group of values, separated by a comma. Everything that matches any of the values listed will appear in the list.

Not in: You will enter a group of values, separated by a comma. Everything that does not match any of the values listed will appear in the list.

Between: This is used to filter for date periods. This will display anything between the beginning and ending dates selected.

Not between: This will display anything that is not within the beginning and ending dates selected.


When adding multiple filters, you have the option to select AND, OR, or NOT.


AND: If an additional filter is added, the items being filtered will need to match the first filter condition AND the second filter condition. If it just matches the first, or just matches the second, it will not appear in the list.

OR: If an additional filter is added, the items being filtered will need to match either the first filter condition, the second filter condition, or both conditions. If it matches just one of the conditions, it will appear in the list.

NOT: This is used to filter for certain records, while eliminating certain records that may meet the conditions of the first filter. (Ex: You want to filter for numbers between 1-5, but you don't want the number 4 included. The first filter will be used to find what you want (1-5). The additional filter will be used to eliminate what you don't want.(4) The results will then list numbers 1,2,3, and 5.)