AnsweredAssumed Answered

Simple workflow request

Question asked by Shanelle Blake on May 14, 2020
Latest reply on May 18, 2020 by Clive Morrish

Hi everyone.
Can I ask for "easy" help?
I am studying the workflows within IGL 7.1.
I would like to ask you for a little help as documentation is not so clear for me.


In an authorization workflow of a request, I would like to make a simple external SQL call to verify a value and, based on the result of the query, give OK or KO to the request. I think it is easy but I have never seen how it is done.


For example I would like to put a decision in the middle of the workflow that says:
- query to a db (maybe the same igl db if possible).

  if the user for whom authorization is requested has title=manager then ok, approve otherwise deny the request.

I can't understand how to creta a value with the result of the query and to use it for subsequent processes (ok or deny).
Can you help me with an example?
Thank you very much!!!!