Mr. Walker,
Thanks very much for your reply!! I tried your suggestion and it got rid of my errors, but I'm still not sure I'm doing things correctly.
I added the query and it doesn't look like I'm getting the part and partrev records joined. From what I have seen elsewhere, what I have looks like it might work, but I don't think I'm getting the part record from the partrev part number. It looks like it should be fairly simple, but I'm not used to the BPM way of life yet. This is what I'm trying:
for each Part no-lock , each PartRev
where Part.PartDescription MATCHES('*CUST , *')and Part.PartNum = PartRev.PartNum
Again, that you very much for your help.
Regards,
Kurt
Thanks very much for your reply!! I tried your suggestion and it got rid of my errors, but I'm still not sure I'm doing things correctly.
I added the query and it doesn't look like I'm getting the part and partrev records joined. From what I have seen elsewhere, what I have looks like it might work, but I don't think I'm getting the part record from the partrev part number. It looks like it should be fairly simple, but I'm not used to the BPM way of life yet. This is what I'm trying:
for each Part no-lock , each PartRev
where Part.PartDescription MATCHES('*CUST , *')and Part.PartNum = PartRev.PartNum
Again, that you very much for your help.
Regards,
Kurt
--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> Try MATCHES("*Cust,*")
> The leading * and trailing * will find it anywhere in the description
>
> --- In vantage@yahoogroups.com, "Kurt" <iusevantage@> wrote:
> >
> > Hi everyone,
> >
> > I have what seemed initially to be easy is giving me a real problem. Basically, I have a BPM that sends out an email when a new part rev is created and the part number starts with several specific characters. This works just fine. But I was just asked to filter that by checking for if the part description contains certain characters, one being "CUST,". I can see where if the field starts with specific characters to use that record, but I can't see how to filter out if the field contains specific ones. I have tried using LIKE (similar to SQL) and CONTAINS and both get me errors. I'm not overly familiar with PBM's yet and learn case by case, which up to now has been ok, but I'm stuck on this. Can anybody offer assistance?
> >
> > Thanks in advance for your help!
> >
> > Kurt
> >
>