Integration

Get Involved. Join the Conversation.

Topic

    Nagesh Manda
    Business Events Filter ConditionAnswered
    Topic posted August 16, 2019 by Nagesh MandaSilver Medal: 2,000+ Points, tagged Events, Integration 
    31 Views, 4 Comments
    Title:
    Business Events Filter Condition
    Content:

    Hi All,

    I am unable to add the below filter condition for the business events received from ERP Cloud. Could you let me know if it is possible to add multiple conditions within the filter section.

    <xpathExpr xmlns:ns_0="http://xmlns.oracle.com/adf/svc/types/"
    xmlns:ns_1="http://xmlns.oracle.com/apps/scm/receiving/receipts/receivingTransaction/"
    xmlns:ns_2="http://xmlns.oracle.com/apps/scm/receiving/receipts/receivingTransaction/types/">$eventPayload/ns_2:result/ns_0:value/ns_1:TransactionType="RETURN TO VENDOR" AND $eventPayload/ns_2:result/ns_0:value/ns_1:OrganizationCode="PPG" </xpathExpr>

     

    Thanks,

    Nagesh.

    Image:

    Best Comment

    Jihane
    I think the operators are case sensitive Can you try and Lower case Another suggestion is to seperate condition by parentheses And try single quote instead of double quote.

    Comment

     

    • Monish Munot

      Is the single condition working for you?

    • Nagesh Manda

      yes it is working Monish.

    • Jihane
      I think the operators are case sensitive Can you try and Lower case Another suggestion is to seperate condition by parentheses And try single quote instead of double quote.
      • Nagesh Manda

        Thanks Jima.

        The expression is working after making the changes.

        <xpathExpr xmlns:ns_0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns_1="http://xmlns.oracle.com/apps/scm/receiving/receipts/receivingTransaction/" xmlns:ns_2="http://xmlns.oracle.com/apps/scm/receiving/receipts/receivingTransaction/types/">$eventPayload/ns_2:result/ns_0:value/ns_1:TransactionType='RETURN TO VENDOR' and $eventPayload/ns_2:result/ns_0:value/ns_1:OrganizationCode='***' </xpathExpr>