on 04-16-2020 11:19 AM
Hi Experts,
I'm migrating an interface from PI Dual Stack to PO 7.5 single stack.
I have a complex receiver determination condition in my existing interface, however while migrating these condition doesn't seem to be working in the condition editor in eclipse.
I have used EXISTS and xpath using white spaces option as well.
Could you please help me to implement the following condition in eclipse?
(ZDELVRY07/IDOC/E1EDL20/E1EDL24/E1EDL41[not(substring(BSTNR,1,3) = 'SOS' and QUALI=001)] EX ) OR (ZDELVRY07/IDOC/E1EDL20/E1EDL24/E1EDL41[substring(BSTNR,1,3) = 'SOS' and QUALI=001] EX AND ZDELVRY07/IDOC/E1EDL20/E1ADRM1[PARTNER_Q = 'RG' and not(PARTNER_ID=11111)] EX )
I also want to know if I can add additional conditions with it using AND statement.
(ZDELVRY07/IDOC/E1EDL20/E1EDL24/E1EDL41[not(substring(BSTNR,1,3) = 'SOS' and QUALI=001)] EX ) OR (ZDELVRY07/IDOC/E1EDL20/E1EDL24/E1EDL41[substring(BSTNR,1,3) = 'SOS' and QUALI=001] EX AND ZDELVRY07/IDOC/E1EDL20/E1ADRM1[PARTNER_Q = 'RG' and not(PARTNER_ID=11111)] EX )
AND /ZDELVRY07/IDOC/EDI_DC40/RCVPRN = “XYZ” AND ....
Thanks,
Shubham
Hi Shubham,
no, neither the condition editor in Integration Directory nor the editor in the Integration Flow support "does not contain pattern". You have to use "not equals" instead.
Best regards
Anna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anna,
No this doesn't seem to work.
I have worked to make these conditions simpler.
But I'm stuck how to achieve Not condition or Does not Contain option in Xpath.
In the condition editor of PO 7.5, the only two Boolean operator are AND and OR.
When I try to use NOT, the condition editor doesn't accepts it.
Similarly, there is a contains pattern option but not a "does not contain pattern"
I'm trying to achieve the following:
(Xpath./ZDELVRY07/IDOC/EDI_DC40/RCVPRN = "ABC" AND Xpath.Partner = "111111" AND Xpath.BSTNR *does not contain* "xyz") (xyz is the first three characters of the string xyzabc123)
And Xpath.BSTNR is created using the option to create Xpath containing white spaces as follows:
/ZDELVRY07/IDOC/E1EDL20/E1EDL24/E1EDL41[QUALI = "001"]/BSTNR
Is there a way to use NOT or DOES NOT Contain Patterm in condition editor?
Thanks,
Shubham
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Subham,
following statement compiles without errors in the condition editor:
(EXISTS(Xpath.ZDELVRY07/IDOC/E1EDL20/E1EDL24/E1EDL41[not(substring(BSTNR,1,3) = 'SOS' and QUALI=001)])) OR ( EXISTS(Xpath.ZDELVRY07/IDOC/E1EDL20/E1EDL24/E1EDL41[substring(BSTNR,1,3) = 'SOS' and QUALI=001]) AND EXISTS(Xpath.ZDELVRY07/IDOC/E1EDL20/E1ADRM1[PARTNER_Q = 'RG' and not(PARTNER_ID=11111)]))
I haven't check if it has the desired result at the runtime.
Best regards
Anna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
10 | |
8 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.