PS Query Lists
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page PS Query Lists
| Line 6: | Line 6: | ||
2: Leave the expression settings as their defaults - a character expression with a length of 1. | 2: Leave the expression settings as their defaults - a character expression with a length of 1. | ||
3: As an example, to make a list of Departments containing Sales, Marketing, Operations put the following into the expression list: | 3: As an example, to make a list of Departments containing Sales, Marketing, Operations put the following into the expression list: | ||
| - | + | <pre> | |
A.DEPTID in ('SALES','MARKETING','OPERATIONS') and 'a'= | A.DEPTID in ('SALES','MARKETING','OPERATIONS') and 'a'= | ||
| - | + | <\pre> | |
4: Click OK and save the expression and return to your new criterion. | 4: Click OK and save the expression and return to your new criterion. | ||
5: Add the right hand side of the criterion as the constant value "a" (without the quotes) | 5: Add the right hand side of the criterion as the constant value "a" (without the quotes) | ||
