Entering conditions on a field

The Field Condition dialog allows you to enter conditions for a specific field.

There are four places in iBridge Designer where you may wish to do this:

setting conditions on an entity sub type
setting conditions on a link end
defining a filter in a code list
defining a filter on an entity or link type

Enter the field name, an operator and a value.

If you select the is like or isn't like operator, you can use the following wild cards in the Value box for text fields:

* indicates zero, one or more letters

? indicates exactly one letter

To include an asterisk (*) or question mark (?) in the condition itself, prefix them with a backslash (\). To include a backslash (\) in the condition you must type it twice.

For example:

H* searches for text beginning with H with any number of characters following

C*t searches for text beginning with C followed by any number of characters followed by t

help\? searches for the text help?

\\example searches for the text \example

Note: When setting conditions on a link end or when defining sub type conditions, if you are performing any text comparisons, that is on string or memo fields, the comparison will be case sensitive. Also, only the above wildcards (* and ?) will work for the is like and isn't like operators.

Note: When setting filters on types or defining filters in a code list, the case sensitivity depends on your database. You may also find that you can use other wildcards for like and isn't like operators depending on the database. These are not documented. The case sensitivity status and any other acceptable wildcards in these dialogs will also be true for analysts in the Find and Query dialogs. You may wish to provide this information for them in the Database Characteristics. See Viewing details of a selected issue.