Workflow - same time multiple processing

[AdrianMarchis]

Hello,

We created a workflow that runs from an "if/else" condition to resource owner if true and to the manager if false.

Is it possible to run the "if true" condition on both resource owner and manager flow at the same time?

This is the current setup (and it works):

This is the setup we would like to run:

The expected output is to have the generated task approved by both sides, the resource owner and the manager.

Is this something that can be achieved? searching the forum returned no results.

Thank you!

[NM]

Hi @AdrianMarchis , you can use a custom assignment block

Write a query to send the request to both manager and resource owner for approval.

[rushikeshvartak]

Use below queey

select userkey from request_Access ra where ra.REQUESTKEY=${ARSREQUEST.id} union

select e.requestowner as userkey from endpoints e where e.endpointkey= 1167

[AdrianMarchis]

Thank you @NM @rushikeshvartak I will test it out and post the result.

[AdrianMarchis]

@rushikeshvartak The query provided is not working - "Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{ARS.id} UNION SELECT e.requestowner AS userkey FROM endpoints e WHERE e.endp' at line 3"

[rushikeshvartak · Accepted solution]

It seems you have typo in your query [{ARS.id}]

select userkey from request_Access ra where ra.REQUESTKEY= ${ARSREQUEST.id} union select e.requestowner as userkey from endpoints e where e.endpointkey= 1167

[AdrianMarchis]

@rushikeshvartak Still not working - Error parsing '#{(select userkey from request_Access ra where ra.REQUESTKEY= ${ARSREQUEST.id} union select e.requestowner as userkey from endpoints.get(requestaccesskey) e where e.endpointkey= 1167) eq true }': syntax error at position 10, encountered 'userkey', expected ')'

In Data Analyzer - Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{ARSREQUEST.id} union select e.requestowner as userkey from endpoints e where e.' at line 1

[rushikeshvartak]

Where are you using query ? Share workflow wiring screenshot.

Query needs to be used in custom assignment block - custom query section

[AdrianMarchis]

@rushikeshvartak The full workflow is too large to capture a screenshot. We'd like to use the expression in an If/Else custom field.

[rushikeshvartak]

You can't use select in if else loop.

Use below condition

endpoints.requestowner eq user.manager