When adding a selection criteria clause to a script, remember the following guidelines:
Surround the entire selection criteria with double quotation marks and surround individual string values with single quotation marks.
Complex clauses can be created by grouping values. For example,
“(Job.ID > 100000015) and ((Job.Duplex = ‘Yes’) or (Job.TotalPages > 100))”
Job and document attributes cannot be combined in the same clause.
Date and time values must be in a format that can be converted from a text string to a timestamp. This format is
YYYY-MM-DD HH:MI:SS:FFFFFF. The full timestamp can be shortened, for example
The following table describes the operators you can use in selection criteria clauses.
|=, !=, <>, >, >=, <, <=||The available comparison operators.||
|and||Returns results that meet all the specified criteria. In the example, only jobs that have both a Job.ID of 100000015 and a Job.Name of AcmeMortgage are returned.||
|in||Returns results for values that belong to a membership. In the example, only the results for jobs that have a Job.ID of 10000015, 10000020, or 10000023 are returned.||
|like||Returns a value that matches a specified pattern. You can use the following wildcards.
|not||Returns results that do not meet the specified criteria. It can be used with other operators. In the example, all jobs with a Job.ID greater than 100000015, except for 10000020, are returned.||
|or||Returns results that meet any of the specified criteria. The jobs do not need to meet all specified criteria to be returned. In the example, jobs with the Job.Name AcmeMortgage or AcmeInsurance are returned. A job would not need to have two Job.Name values to meet the specified criteria.||