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.
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’