PS Query Lists
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page PS Query Lists
(→Creating the List) |
|||
| Line 4: | Line 4: | ||
1: Create a new criterion - and make the left hand side an expression. | 1: Create a new criterion - and make the left hand side an expression. | ||
| + | |||
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> | <pre> | ||
| Line 10: | Line 12: | ||
</pre> | </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) | ||
| Line 19: | Line 22: | ||
1: Put the raw list in the left hand "source" box. | 1: Put the raw list in the left hand "source" box. | ||
| + | |||
2: Depending on your platform, input the following into the "Regular Expression" box: | 2: Depending on your platform, input the following into the "Regular Expression" box: | ||