Parameter Operators The operators that are available for use depend on the data type of the field you are working with. The following table outlines the operators available. OPERATOR DESCRIPTION Data types Between Returns all data between the two values you provide. For example, if you choose a field that contains text, and search between A and C, it will return all values that start with the letters A, B and C. String Number Date Contains Returns all data containing the value you provide. The value can be found anywhere within the field. For example, if you enter AN, as long as that sequence of letters is found anywhere in the field, the data is returned. This is a very flexible operator. Many of the operations you can do with Contains can also be done using other operators. It is primarily intended for use with wildcard characters. Supported characters (for strings only): • *, which replaces any number of characters • ?, which replaces a single character. Returns all data that matches the combination of text and wildcards that you provide. For example: • Fin* returns all data that starts with Fin, and has any number of characters after it. (For this case, you could also use the Starts with operator) • Fin? returns anything that starts with Fin and has a single additional character. • *Finance returns any data that ends with Finance. (For this case, you could also use the Ends with operator) • *Finance* returns any data that has Finance anywhere in the field. (For this case, you could also use the Contains operator.) • F*e excludes any value that starts with F and ends with e. String Does not Contain Returns all data except those containing the value you provide. For example, if you enter AN, if that sequence of letters is found anywhere in the field, the data is not returned. You can use wildcards in the same manner as Contains. String Does not end with Returns all data except that ending with the value that you provide. String Does not start with Returns all data except that starting with the value that you provide. String Ends with Returns all data that end with the value you provide. String Equals Returns only the data that exactly matches the value you provide. Equals is not case sensitive. String Number GUID Boolean Date Equals with group expansion Enter an Account Name. Results include the data for the selected account as well as the data for any group of which it is a direct or indirect member. For example, if an account is a member of Group A and Group A is a member of Group B, the results will include values/data for the account as well as Group A and Group B. Account Name attribute only Excludes You provide a list of values. Returns all values except those matching your list. This acts as an OR when joining the list you provide—it returns data that does not match any one of the values. For example, if your Excludes list is Austin, Dallas and Houston, if a field includes any of the values, the data will not be returned. Supported wildcards (for strings only): • *, which replaces any number of characters • ?, which replaces a single character. For a full explanation of the use of these wildcards, see Contains. String Number Date Greater or equal to Returns all data larger than and including the value you provide. String Number Date Greater than Returns all data larger than the value you provide. String Number Date Has a value Has two possible values: True or False. If you choose True, returns all data where the field is populated. If you choose False, returns all data where the field is empty. String Number Boolean Date In the next Enter a number of days. Returns data with a date range from the date and time you run the report to the number of days in the future that you enter. For example, if you run the report at 16:30 on December 12, and you enter six days, you will get data with the dates from December 12 at 16:30 to December 18 at 16:30. Date In the past Enter a number of days. Returns data with a date range from the date and time you run the report to the number of days in the past that you enter. For example, if run the report at 16:30 on December 12, and you enter six days, you will only get data with a date from December 6 at 16:30 to December 12 at 16:30. Date Includes You provide a list of values. Returns all values that match any item on your list. This acts as an OR when joining the list you provide—it returns data that does not match any one of the values. For example, if your Includes list is Austin, Dallas and Houston, if a field includes any of the values, the data is returned. Supported wildcards (for strings only): • *, which replaces any number of characters • ?, which replaces a single character. For a full explanation of the use of these wildcards, see Contains. String Number Date Less than Returns all data smaller than the value you provide. String Number Date Less than or equal to Returns all data smaller than and including the value you provide. String Number Date Matches You select two fields. Returns only the data where the contents of one field is identical to the other field. Matches is not case sensitive. String GUID Not between Returns all data that is not between the two values you provide. For example, if you choose a date field, and set the values to not between December 10, 2011 and January 15, 2012, you will get all corresponding data from December 10 and before, and January 15 and after. You must enter the lower value first, followed by the higher value. String Number Date Not equals Returns all data except for the value you provide. String Number Date Boolean GUID Not in the next Enter a number of days. Returns all data except for the time period from the date and time you run the report to the number of days in the future that you enter. For example, if you run the report on December 12 at 16:30, and you enter six days, you will get all data except that with a date from December 12 at 16:30 to December 18 at 16:30. Date Not in the past Enter a number of days. Returns data with any date except for the time period from the date and time you run the report to the number of days in the past that you enter. For example, if you run the report at 16:30 on December 12, and you enter six days, you will get all data except that with a date of December 6 at 16:30 to December 12 at 16:30. Date Starts with Returns all data that starts with the value you provide. String
