AnsweredAssumed Answered

Clear Job Variables in a Workflow

Question asked by Prateek Bhatnagar on Aug 29, 2016
Latest reply on Sep 7, 2016 by Prateek Bhatnagar

Like • Show 0 Likes0
Comment • 5

Hello,

I am working on a custom task which will loop over a result set, returned by a SQL SELECT statement, and do some work. To do work in a loop, I am using the next value node in my workflow. After the WF runs and next value node evaluates to False, I see in runtime data, a new variable created called AppNameIndex = # of total rows in the dataset.

I am just wondering how can I clear the value of this AppNameIndex variable once Next Value node evaluates to false? I tried setting it to 0 and to an empty string '' using set value and SELECT node but either approach didn't work.

We're on RSA Via 6.9.1 P10.

Mostafa Helmy

Aug 30, 2016 1:52 PM

Correct Answer

I tried modifying its value before (as I was trying to access a specific index) but failed. I haven't tried to set its value to null though (which I guess is more logical in your case since you want to totally remove the variable).

Try something like this in a SQL Select node (I haven't tested it though):

select null as AppNameIndex from dual

See the reply in context

No one else had this question

Outcomes

Prateek Bhatnagar Aug 30, 2016 1:42 PM

Any thoughts on how to de-initialize the Index variable which is created by a next value node?

Actions

Mostafa Helmy

@ Prateek Bhatnagar on Aug 30, 2016 1:52 PM

Try something like this in a SQL Select node (I haven't tested it though):

select null as AppNameIndex from dual

Actions

Prateek Bhatnagar @ Mostafa Helmy on Aug 30, 2016 1:59 PM

It worked!!!

Earlier I was setting the Index variable to numeric 0 instead of NULL, setting it to NULL like you suggested did the trick!!

Actions

Andy Cheek Sep 5, 2016 11:49 AM

Why would you care? As far as I can see that is a system generated variable to hold the loop counter while the workflow is doing all the For Next type processing. Once the loop is complete it is irrelevant and (presumably) of no interest to you.

Actions

Prateek Bhatnagar @ Andy Cheek on Sep 7, 2016 2:27 PM

Hi Andy,

You are correct but I am implementing batch processing where if there are 100 records to process in total, I want to pass only 15 records at a time to the node doing the work, and then send control back to SQL SELECT to return next 15 records, and so on till we process all 100 records.

In this case, I want to ensure after first batch run, all system variables are cleared out.

-Prateek

Actions

5 Replies

Prateek Bhatnagar Aug 30, 2016 1:42 PM
Mark Correct
Correct Answer
Any thoughts on how to de-initialize the Index variable which is created by a next value node?
Like • Show 0 Likes0
Actions
- Mostafa Helmy @ Prateek Bhatnagar on Aug 30, 2016 1:52 PM
  Unmark Correct
  Correct Answer
  I tried modifying its value before (as I was trying to access a specific index) but failed. I haven't tried to set its value to null though (which I guess is more logical in your case since you want to totally remove the variable).
  
  Try something like this in a SQL Select node (I haven't tested it though):
  
  select null as AppNameIndex from dual
  Like • Show 1 Like1
  Actions
  - Prateek Bhatnagar @ Mostafa Helmy on Aug 30, 2016 1:59 PM
    Mark Correct
    Correct Answer
    It worked!!!
    
    Earlier I was setting the Index variable to numeric 0 instead of NULL, setting it to NULL like you suggested did the trick!!
    Like • Show 0 Likes0
    Actions
Andy Cheek Sep 5, 2016 11:49 AM
Mark Correct
Correct Answer
Why would you care? As far as I can see that is a system generated variable to hold the loop counter while the workflow is doing all the For Next type processing. Once the loop is complete it is irrelevant and (presumably) of no interest to you.
Like • Show 0 Likes0
Actions
- Prateek Bhatnagar @ Andy Cheek on Sep 7, 2016 2:27 PM
  Mark Correct
  Correct Answer
  Hi Andy,
  
  You are correct but I am implementing batch processing where if there are 100 records to process in total, I want to pass only 15 records at a time to the node doing the work, and then send control back to SQL SELECT to return next 15 records, and so on till we process all 100 records.
  
  In this case, I want to ensure after first batch run, all system variables are cleared out.
  
  -Prateek
  Like • Show 0 Likes0
  Actions

Clear Job Variables in a Workflow

Outcomes

Related Content

Recommended Content