You can define expressions to filter PowerDesigner lists directly in the list with the in-column filters or through the Customize Columns and Filter dialog.
The following operators are available
Operator |
Finds items that are... |
---|---|
= |
[default] Equal to the expression. |
> |
Greater than the expression. |
>= |
Greater than or equal to the expression. |
< |
Less than the expression. |
<= |
Less than or equal to the expression. |
Not Equal |
Different from the expression. |
In List |
Within the comma-separated list of values given in the expression (or the items selected in the list in the in-column filter). For example:
"global", "Architecture", "proc*" |
Not In List |
Outside the comma-separated list of values given in the expression (or the items selected in the list in the in-column filter). |
Between |
Located in the range between defined by the two values given in the expression and separated by a comma. For example, to find values between A and E, enter:
A,E |
Not Between |
Located outside the range defined by the two values given in the expression and separated by a comma. For example, to find values outside of the range between A and E, enter:
A,E |
Empty |
Null. No expression is necessary with this operator. |
Not Empty |
Not null. No expression is necessary with this operator. |
You can use the following wildcards when entering a filter expression:
Wildcard |
Description |
---|---|
* |
Any string (from none to any number of characters). For example P* finds "protocol" and "Paris". |
? |
Any character. For example ????? finds "Table" and "inner" but not "Seller". |
\ |
Escapes the special characters *, ?, and \ . For example, \?\\ finds "?\". |