In receipt entry when the “Received” checkbox is set to true, I need to check the Part.LotShelfLife value. If the shelf life value is greater than 0, display a message. The issue is that within the BPM workflow designer, when selecting the condition “The specified field of the the changed row is equal to the specified expression” and then clicking the first “specified,” Part.LotShelfLife isn’t referenced. How can I access this field?
run a condition for when the “number of rows in query is less than 1”(or whatever you need to set), and set up your conditions to go look for that field.
This can get you true/false information. If you need the actual value in the message, that’s harder.
Wouldn’t this only tell how many rows meet a condition? I need to know the value of the field so that I can show it as true or false, depending on if its value > 0.
You can set the criteria in the query for >0. But you won’t get the actual value out of it. Just whether or not it passes the criteria. If you have one item in the receipts, you will get a true response and you can show the message. You won’t be able to see which row, but you will know that there is at least a row that meets the criteria.
It may not be an advanced enough solution to get what you want, it depends on how specific you need to be.
1 Like