I have a MySQL table called Product which has columns id, orderDate and received

I have a MySQL table called Product which has columns id, orderDate and receivedDate (plus others). OrderDate gets set within the main flow, which then needs to pause until the product has been received - ie receivedDate is not null.

The receivedDate gets set by a Related Action.

How can I get my main flow to detect that receivedDate has been set, and then continue?

I tried creating a rule called 'IsProductReceived' that contains a queryEntity to return true if the receivedDate is not null, otherwise returns false. This works as expected when I test it in isolation.

I put this rule into the expression of a Rule Event. When I execute the Rule Event, I get an error "ERROR:EVAL:@reason=index".

Am I attempting to do this in the right way and have some error in my rule, or am I using the wrong method to do this?

OriginalPostID-147702

OriginalPostID-147702