Wildcards in Generic sort filter

[Former Member]

Hi,

is it possible to use wildcards in the Generic sort filter in transactions? And if yes, which ones?

Problem is the following: I get a list of orders from SAP, and I want to select only the orders that are released, so I have to filter on Orderstatus 'REL', the rest of the status can differ according to different situations of the order, so I don't want them in my filter.

[salvatore_castro · Accepted solution]

You can also perform this via XPath but it will not be quite as fast as the complied action code, here's the syntax:

JCoCall.ResponseXML{/BAPI/SomePath *Square Bracket* contains(StatusCode, "REL") *Square Bracket* /Item}

For more examples and ideas see:

[http://www.w3schools.com/Xpath/default.asp|http://www.w3schools.com/Xpath/default.asp]

Hope this helps,

Sam

PS: Sorry about the *Square Bracket* piece it interprets it as a link otherwise.

[Former Member · Accepted solution]

Filter works now, thanks both of you!

[Former Member]

Its going to be tricky. I remember using "match" function. String "REL". Remember to include "PCONF".

You may want to try the other way - exclude those that are "CRTD", "CONF", "DLV", "TECO" etc.

Chanti.