Updating JobMtl Record during Get Details with BPM

mikelee · February 19, 2019, 10:17pm

When I use double quotes “Glass” it works but keeps returning false. Am I not using the wildcards properly?

Banderson · February 19, 2019, 10:17pm

try %

mikelee · February 19, 2019, 10:19pm

Still returning false. The record has Glass right in the description but always has text before and after.

Banderson · February 19, 2019, 10:20pm

I’m trying some stuff too. Instead of = try matches.

mikelee · February 19, 2019, 10:21pm

False again

Banderson · February 19, 2019, 10:26pm

run a message box with the rows to see what’s actually coming back. What does your condition look like? Do you have the logic set up right in that?

Banderson · February 19, 2019, 10:35pm

Try this condition instead. (obviously with your tables and constant)

I couldn’t get the query to work with wild cards either, and honestly it’s probably not a good thing to do performance wise.