Hi,

I want to run a process for all the records of a section where the business process reads two values of the respective record, modifies a field in that particular record and then does the same for every record in the section.

But I am not sure how to run the process for every single record. I am using Read data element and Reading the first record in the selection which gives the results for the last record that was created in the system but it does not run for every record in the section.

Could someone help?

Like 1

Like

5 comments

I think u can use 'flag' . U can create a new field in the table (not displayed on UI) , mark it 'N' as default for all the records and run the process in loop and update every time it is  N and set the particular record 'Y'  after processing . U can also set how many times the loop should run, default value is 100 u can update it a value according to the data size you are trying to work upon!!  I hope that helps . 

Shailey,

 I already have a lookup and I want to run the process based on the value of that lookup. Will that work or is it essential to have that flag? Can that lookup not act as the flag?

aaykay,

You can use record tag also. First put tag for all records which have specific value for the lookup as "to be processed", then on by one read all records with this tag, after processing, change the tag to some other tag say "processed"

Hi,

I am following as you suggested but the process only runs for the first record.

Shailey writes:

I think u can use 'flag' . U can create a new field in the table (not displayed on UI) , mark it 'N' as default for all the records and run the process in loop and update every time it is N and set the particular record 'Y' after processing

Show all comments