Well, From what you tried, how would you run this query in the middle of the proccess? I mean, as you said, the information will disappear after the proccess finish, and in my case, the proccess will finish in a step after i got the approval, so i need to run a GEL script and put it in a step right away after the action item step in the proccess so i can get the log of who approve or who reject or whatever... we need that to implement the SAS70/SSAE16 gates, we are thinking of building these gates in our clarity, so I need to get all the details about tasks and who approves the tasks (I have to build a task level approval proccess).
If anybodya have any idea or suggestion about that thing it will be great help for us!
thnak you Chris!
You are on the right track. The approval data is cleared out at the end of the process. Our process is laid out like this (simplified)
<start process>
Step 1 - Create Action Item - This goes to a resource on the project and asks them to approve or reject it.
The process is in a waiting state until the resource approves or rejects it.
Step 2 - GEL Script to record the audit - This is where the script I referenced above is used to read the out of the box clarity table. Since the process is still "running" at this point, the data in the table is referenced and we can see that John Smith approved his action item. In a separate script (not shown) after that, we do a simple sql update to update a custom Z_PROCESS_AUDIT table that houses who the action item was sent to, and the result. Since this is 100% custom, you can add project id's, task id's, whatever else you want to track for your reporting needs.
<end of process>
I hope that helped.