Filters Dialog Box
Use the Filters dialog box to create one or more filter expressions using any properties in the message context.
The expression pane on the right displays an empty grid in which you can add expressions. In each expression, you compare a message property with a constant. You can change the order in which Microsoft BizTalk Server evaluates the expressions and how it groups them into the final filter. To view the results of your work, click Show Filter Expression on the toolbar.
In the expression pane, click Click here to add a new row to add a property, operator, value, and group by value to your expression.
Use the Expression editor to specify the following options.
| Use this | To do this |
|---|---|
|
Property |
Type or select a property reference. The list contains properties for the incoming message. |
|
Operator |
Type or select an operator for the expression. Options:
|
|
Value |
Type the value to validate.  Note
You map decimal values entered in the Value column for an integer property to an integer when you create the subscription. The decimal value is truncated to map to the integer, for example, a value of 9.4 will be mapped to 9, a value of 9.5 or 9.9 will be mapped to 10. Note
You must express time values entered in the Value column for a datetime property in .NET-supported time formats. For more information about .NET-supported time formats, see "DateTimeFormatInfo Class" in .NET Frameworks Help. Note
Filter expressions in send ports should not include double quotes around the value, in contrast to filters in orchestrations, which require that the value is enclosed in double quotes. If configured for use in an orchestration filter, the example given above would be BTS.ReceivePortName == "recPort1". |
|
Group |
Use this column to control predicate grouping. You always express filter expressions in Disjunctive Normal Form (DNF) so grouping can be determined automatically. AND means to group the predicate with the predicate following it, while OR means the predicate is separate from the predicate in the next row. Gray brackets to the left of the grid control appear when you group the predicates together. You cannot nest predicate groups. If you do not specify a value in this cell, the value of the cell defaults to AND. |
After you create the expression, click OK.
