IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Provider Filter Only (UM Only) - webMethods Messaging Trigger

  • 1.  Provider Filter Only (UM Only) - webMethods Messaging Trigger

    Posted Mon September 19, 2016 07:41 AM

    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.


    #Universal-Messaging-Broker
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Provider Filter Only (UM Only) - webMethods Messaging Trigger

    Posted Mon September 19, 2016 09:19 AM

    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


    #Integration-Server-and-ESB
    #Universal-Messaging-Broker
    #webMethods


  • 3.  RE: Provider Filter Only (UM Only) - webMethods Messaging Trigger

    Posted Tue June 13, 2017 12:40 PM

    try this:

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

    -HTH


    #webMethods
    #Integration-Server-and-ESB
    #Universal-Messaging-Broker


  • 4.  RE: Provider Filter Only (UM Only) - webMethods Messaging Trigger

    Posted Tue June 13, 2017 12:47 PM

    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’


    #webMethods
    #Universal-Messaging-Broker
    #Integration-Server-and-ESB