Skip to main content

Hi,

currently I am facing problem, to modify an existing Process Flow based on ETA criterias 

(Goal is to do something only when ETA datetime is > NOW )

 

But as this is not working, I had the idea to create a workaround via ProcessFlow Data Query. But I don’t know, if it is possible to “handover” the order_id from ProcessFlow to SQL syntax. Does anyone know if this is possible, or not?

Please see pictures to understand better.

 

Thanks a lot in advance and a nice weekend to all.

 

Regards

Torsten

 

 

 



 

 

Did you try building a new Process Flow Data Query for the source to grab the information you needed using the conditions where the service_call.contr_eta is > getdate()?

You can take a look at the Process Flow User Guide.pdf that comes with your v15.3 environment for more information.

Alternatively, though it is recommended to use the above, I also saw this in this document where instead of a manual condition, you can choose this option:

 

Did you try building a new Process Flow Data Query select the source from SQL?  For example, I think you would need to use a where condition for the service_call.contr_eta > getdate() to achieve what you wanted to select.

Just a thought.

Hi,

thanks a lot, Phil!

Today I had a session with Ingo related this, he showed me the function of “Process Flow Query Conditions”, that is exactly that what I needed. Combine event based process flow with SQL query.

 

If someone else want to use this very interesting function, here is an example syntax:

 

Regards

Torsten

Hi Torsten,

Glad we were able to point you in the right direction and get this resolved for you!

Phil

Reply


Terms & ConditionsCookie settings