Provider Filter Only (UM Only) - webMethods Messaging Trigger

Hi,
someone know the syntax to create a filter on UM for a “webMethods Messaging Trigger”?

Now I have a local filter in the trigger:

%documentOne/var1% = ‘value1’ && %documentOne/var2% = ‘value2’

What is the correct syntax that I have to use in the configuration field in the trigger “Provide Filter (UM Only)”?
Thanks in advance.

1 Like

The Service Development Help just shows very limited examples, the extra syntax you could refer to UM Developers’ Guide, in which I could find the expression below.

EXPRESSION ::=
|
<LOGICAL_OPERATOR> |
<ARITHMETIC_EXPRESSION> |
<CONDITIONAL_EXPRESSION>
ARITHMETIC_EXPRESSION ::=
<ARITHMETIC_EXPRESSION> <ARITHMETIC_OPERATOR> <ARITHMETIC_EXPRESSION> |
<ARITHMETIC_OPERATOR> <ARITHMETIC_EXPRESSION> |
<ARITHMETIC_EXPRESSION> <ARITHMETIC_OPERATOR>
CONDITIONAL_EXPRESSION ::=
<COMPARISON_OPERATOR> |
<LOGICAL_OPERATOR> <COMPARISON_OPERATOR>
ELEMENT ::=
<DICTIONARY_KEY> |
<NUMERIC_LITERAL> |
<LOGICAL_LITERAL> |
<STRING_LITERAL> |

LOGICAL_OPERATOR ::= NOT | AND | OR
COMPARISON_OPERATOR ::= <> | > | < | = | LIKE | BETWEEN | IN
ARITHMETIC_OPERATOR ::= + | - | / | *
DICTIONARY_KEY ::= The value of the dictionary entry with the specified key
LOGICAL_LITERAL ::= TRUE | FALSE
STRING_LITERAL ::= <STRING_LITERAL> <STRING_LITERAL> |
Any string value, or if using LIKE,
use the ‘_’ character to denote wildcard
NUMERIC_LITERAL ::= Any valid numeric value
SEPARATOR ::= ,
FUNCTION ::= | | DISTANCE

try this:

%documentOne/var1% L_EQUALS value1 && %documentOne/var2% L_EQUALS value2

-HTH

Saverio,

the syntax using % and L_EQUALS only applies to Broker or to local filters with UM.
Provider filters use a SQL-like syntax, so in your case, assuming you are subscribing to a document that contains a subdocument called documentOne, the syntax would be:

documentOne/var1 = ‘value1’ AND documentOne/var2 = ‘value2’

If var1 and var2 are at the top level within your publishable document, then the filter clause should be:

var1 = ‘value1’ AND var2 = ‘value2’

1 Like