PS Query Lists
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page PS Query Lists
(Created page with "PS Query has a way of comparing a list of values in the criteria to a particular column (or expression). You have to add each value individually - this is a bit of fun for a hand...") |
|||
| Line 7: | Line 7: | ||
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: | ||
| - | A.DEPTID in ('SALES | + | A.DEPTID in ('SALES','MARKETING','OPERATIONS') and 'a'= |
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 a | 5: Add the right hand side of the criterion as the constant a | ||
