AnsweredAssumed Answered

How to check if a workflow variable contains value or not?

Question asked by Ece YILDIRIM on Jun 4, 2016
Latest reply on Sep 5, 2016 by Andy Cheek

Like • Show 0 Likes0
Comment • 3

Hello,

We have a workflow variable named "REQUEST_BOs", created in below SQL select node. It is possible that this variable can contain one, multiple or no values. In a case that variable has no item, we would like to skip subsequent approval step named "Approval - BOs". However, we could not understand how in decision node we can detect if the WF variable contains value or not

*Condition Check with "Exists", "Array Contains Value", "Is An Array" is tried but non of them worked.

- Exists, always resulted in True

- Array Contains Value, resulted in False when there is no or one item.

- Is An Array, resulted in False when there is no or one item.

I need a decision node which will

- return true if variable has one or multiple value

- return false if no value is set.

Any commands please?

resulted in False when there is no or one item.

Tim Willemstein Jun 6, 2016 5:56 AM

Correct Answer

Another solution would be to create a SQL node with some SQL much like the following:

SELECT NVL('${REQUEST_BOs}', 'Empty') as REQUEST_BOS FROM DUAL;

Than use the REQUEST_BOs value in a decision node, if the value is 'empty' than the original request_bos was NULL.

See the reply in context

No one else had this question

Outcomes

Tushar Sutar Jun 6, 2016 3:23 AM

You can use,

1) select * from pv_change_request_variable where change_request_id='oid';

here oid can be obtained from URL, when you click on the change request.

https://myaccessdev.searshc.com/aveksa/main?Oid=68568&ReqType=GetPage&ObjectClass=com.aveksa.gui.objects.changeRequest.G…

2) Add this variable in one of the emails in workflow & check what value gets printed in emails.

Regards,

Tushar Sutar.

Actions

Tim Willemstein Jun 6, 2016 5:56 AM

Another solution would be to create a SQL node with some SQL much like the following:

SELECT NVL('${REQUEST_BOs}', 'Empty') as REQUEST_BOS FROM DUAL;

Than use the REQUEST_BOs value in a decision node, if the value is 'empty' than the original request_bos was NULL.

1 person found this helpful

Actions

Andy Cheek Sep 5, 2016 11:45 AM

We've addressed the same issue in two ways (the original approach and a subsequent alternative).

1. A separate SQL query node which returned the count of objects returned by the previous SQL query. This then enabled a decision node based on the count, i.e. "if COUNT > 0 then ... else ...". That was OK when it was simply a case of retrieving the members of an approver group (for example), but if the original query was more complicated than that we didn't really want to repeat it all just to get a count, so we came up with option 2 ....

2. Retrieve an additional NULL column in the original SQL query, called EMPTYARRAY (or something else equally meaningful). Then you have TWO decision nodes - one to check whether the returned variable is an array (using the Is An Array comparison) and if so, the second to check whether it is empty (using the Equals Array comparison against the EMPTYARRAY variable set in the SQL query), e.g.

Option 1 = 2 SQL nodes + 1 decision

Option 2 = 1 SQL node + 2 decisions

Take your pick !

Actions

3 Replies

Tushar Sutar Jun 6, 2016 3:23 AM
Mark Correct
Correct Answer
You can use,

1) select * from pv_change_request_variable where change_request_id='oid';
here oid can be obtained from URL, when you click on the change request.

https://myaccessdev.searshc.com/aveksa/main?Oid=68568&ReqType=GetPage&ObjectClass=com.aveksa.gui.objects.changeRequest.G…

2) Add this variable in one of the emails in workflow & check what value gets printed in emails.

Regards,
Tushar Sutar.
Like • Show 0 Likes0
Actions
Tim Willemstein Jun 6, 2016 5:56 AM
Unmark Correct
Correct Answer
Another solution would be to create a SQL node with some SQL much like the following:

SELECT NVL('${REQUEST_BOs}', 'Empty') as REQUEST_BOS FROM DUAL;

Than use the REQUEST_BOs value in a decision node, if the value is 'empty' than the original request_bos was NULL.
1 person found this helpful
Like • Show 2 Likes2
Actions
Andy Cheek Sep 5, 2016 11:45 AM
Mark Correct
Correct Answer
We've addressed the same issue in two ways (the original approach and a subsequent alternative).

1. A separate SQL query node which returned the count of objects returned by the previous SQL query. This then enabled a decision node based on the count, i.e. "if COUNT > 0 then ... else ...". That was OK when it was simply a case of retrieving the members of an approver group (for example), but if the original query was more complicated than that we didn't really want to repeat it all just to get a count, so we came up with option 2 ....

2. Retrieve an additional NULL column in the original SQL query, called EMPTYARRAY (or something else equally meaningful). Then you have TWO decision nodes - one to check whether the returned variable is an array (using the Is An Array comparison) and if so, the second to check whether it is empty (using the Equals Array comparison against the EMPTYARRAY variable set in the SQL query), e.g.

Option 1 = 2 SQL nodes + 1 decision
Option 2 = 1 SQL node + 2 decisions

Take your pick !
Like • Show 1 Like1
Actions

How to check if a workflow variable contains value or not?

Outcomes

Related Content

Recommended Content