Defining a Filter Expression

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 "?\".

Examples

The following examples show some possible combinations of operators and expressions:

Operator

Expression

Find

=

W*

Work, Washington

=

*CODE

AREA CODE, COUNTRY CODE, CITY CODE

>

1??

200, 405, 609

Between

O,8

0,1,2,3,4,5,6,7,8

In List

*_emp_???, *_grp_???

div_emp_fun, _emp_idn, div_grp_fun, _grp_idn

=

*\?

Is this book ready for production?