Using the DPA’s Advanced option feature, you can extend the rule to perform two or more comparisons simultaneously. For example, you can set a rule that matches not just age criteria, but also matches employment status.
Open the Rule Properties dialog as described in, Configuring Simple Rules for DPAs.
In the Rule Properties dialog, select the Advanced option.
In the text box, type the Advanced rule.
For string fields, prepend with String:
For date fields, prepend with Date:
For datetime fields, prepend with Datetime:
For number fields, prepend with Number:
For boolean fields, use string field reference with values ‘True’ and ‘False’.
Combine comparisons with a pipe ( | ) if only one of the given conditions must be met, or with an ampersand (&) if both conditions must be satisfied.
For example, to find young or employed people in a biographical data work item, type:
(String:biographicaldata.age=‘young’)|
(String:biographicaldata.status=‘employed’)
To find young people with a salary of more than $50,000 on July 23, 2003, type:
(String:biographicaldata.age=’young’)&
(Number:salary>50000) & (Date:presentdate=07-23-2003)
To find employed people with a salary of more than $50,000 on July 23, 2003 at 01:00 am, type:
(String:biographicaldata.status=‘employed’)&
(Number:salary>50000) &
(Datetime:presentdatetime=07/23/2003-01:00-AM)
Note: Place single quotes around strings.
Please refer to the Accessing Indexed Work Item Properties or more information in accessing indexed work item properties.