Chapter 3 Using the PowerDesigner Interface

Defining a filter expression

If you want to filter the contents of the rows in a list, you can use the Expression field in the customization dialog box. The expression syntax uses the following wildcards and is not case-sensitive:

Wildcard Description
* Represents any string (from none to any number of characters)
? Represents any character
\* * is a normal character
\? ? is a normal character

Expression examples

String expression String values allowed
W* Work

Washington
*CODE AREA CODE

COUNTRY CODE

CITY CODE
????ER Writer

Seller
*_emp_??? div_emp_fun (code for the function of the employee in the division)

_emp_idn (code for the identification of the employee in the division)
*\? Is this book ready for production?

Steps To define a filter expression:

  1. Click the Customize Columns and Filter tool.

    The Customize Columns and Filter dialog box appears.
  2. Type an expression in the Expression column.

    The Used check box in the U column is automatically selected.


    Note   Cancel filter expression
    If you want to keep the expression in memory but disable this filter for a while, you can clear the corresponding check box in the U column. The expression parameter will no longer be taken into account.

  3. Click OK.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.