Hi Experts,
I'm connecting to an external system table which gives me a list of manager's and their reportees (one line for manager and their reportee).
For various reasons, I need to process this table for every manager separately - after processing all reportees for each manager I need to update a specific field for that manager on the Person object which is why a simple ORDER BY won't help.
What I think I need to do is 2 steps:
1) Perform a SELECT DISTINCT on the external table to get a list of all managers
2) Run SELECT queries in a for loop iterating over the managers in the where clause
Question is, how do I store the list of returned values from SELECT DISTINCT into a variable so that I can iterate over it? I tried SQLExecutor but that gives me an integer value to indicate success or failure.
So, to summarize, any way to run a query and store the results in a local variable inside a script?
Thanks in advance
Kin
6.1.4