BPM error

Epicor ERP 10
1

I have a BPM in place that will send an email to one of our tooling engineers if certain conditions are met and I am getting an error : Detail below:

LINQ to Entities does not recognize the method ‘Boolean IsMatch(System.String, System.String)’ method, and this method cannot be translated into a store expression.

Below is the code for the “IsMatch”
where JobMtl_Row.Company == Session.CompanyID && string.Compare(JobMtl_Row.JobNum, ttJobHeadRow.JobNum, true) == 0 && Regex.IsMatch(JobMtl_Row.PartNum, “*U”)

What I need is to identify the part numbers that contain a “U” … Example: 10073U

Any suggestions on how to reword this code?
Thank you,
Carol

2

Try

where JobMtl_Row.Company == Session.CompanyID 
 && string.Compare(JobMtl_Row.JobNum, ttJobHeadRow.JobNum, true) == 0 
 && JobMtl_Row.PartNum LIKE  "%U"

Plus I don’t think you’re using the Regex properly. See

1 Like
3

image

Did something similar to check for a P or a Q in the PO num, this is how i used a Regex in a BPM

2 Likes
4

Thank you … I will give that a try.
Carol