Key Field

Annie

New Member
I have a collection(col1) of four columns data extracted from a table of an application.From (col1) one of the columns(eg:ID No) is takes as a key field in queue as an input for another web application.After checking few results if data not found,then need to go back to (col1) and get another column(eg: Date) for that corresponding ID and compare it with current date and get the days difference and send exception mail to concerned person.

Can someone suggest a solution for the same.
 

VJR

Well-Known Member
Hi Annie,

- After checking few results if data not found,then need to go back to (col1) and get another column (date) for that corresponding ID
- Compare it with current date and get the days difference
- Send exception mail to concerned person


There are 3 requirements so not sure for which requirement you are inquiring about.

For the first one, you can use Filter Collection action to filter the rows of col1 based on that ID No. This will return an output collection corresponding to that ID. Then you can directly access any column of that collection using [CollectionName.DateColumn] if you have one row matching to that ID. In case you have multiple rows you will need to loop through that filtered collection and still access that column using [CollectionName.DateColumn].
 
Top