Data Directive In-Transaction Query Table Criteria MATCHES Operation

Epicor ERP 10
1

I had a Data Directive In-Transaction firing on JobRelease going true and a JobNum MATCHES “%P-%” in 10.1.400 working smoothly (JobNum looks like this 21-11812P-01 ,21-11812P-02 or could be an F or H in the place of the P which I would want to ignore.

When we upgraded to 10.2.500 it will not fire anymore with the MATCHES “%P-%”. Is there a new way to pick off a character in the middle of a field in the DD query editor?

image
image889×172 6.26 KB

I found a work around but would like to use this method again if I have the wrong syntax.

Thanks
Mike

2

You could switch it to “CONTAINS” instead of “MATCHES” and then just remove the wildcard characters.

Looks like “MATCHES” uses RegEx on the back end now.

Try doing this:

".*P-.*"

With .* (period asterisk) being the wildcard.

2 Likes
3

Unfortunately there is no Contains in the BPM Workflow Designer, Compose Query editor

image
image938×799 48.9 KB

However your solution to substitute the (period asterisk) for the (percent symbol) for the wild card did work!

Thank you

Mike

1 Like
4

MATACHES in BPM supports asterisk (*) and probably dot(.) and nothing more.
It is translated to C# code, not to SQL one. So % or _ cannot work.

1 Like