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

paule over 10 years ago

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?

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 10 years ago

@paule As amitl said, you could persist the process id in the database. If you don't want to make any additional changes in the existing database, you could find out the process id you want to target by creating a report and thereby querying the process analytics by using either of the functions - a!queryProcessAnalytics (if you are on 7.8 and 7.8)/ getportalreportdatasubset (Below 7.8), or Execute portal report smart service.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 10 years ago

@paule As amitl said, you could persist the process id in the database. If you don't want to make any additional changes in the existing database, you could find out the process id you want to target by creating a report and thereby querying the process analytics by using either of the functions - a!queryProcessAnalytics (if you are on 7.8 and 7.8)/ getportalreportdatasubset (Below 7.8), or Execute portal report smart service.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data