Can I get the workflow all off reviewer sign off comment in change?
User want to statistic one meek or one month he/she was approved/rejected record and show the signoff comment in the report.How can I get the workflow signoff comment if I have the change number and workflow examination name? (Used DB schema or SDK…alright)
Hi Tonyyu,
It should be possible using query. But you have to play around with these tables.
CHANGE, CHANGE_HISTORY, SIGNOFF and NODETABLE
Regards
Divakar
I will use SDK for this,
- Create search include all changes for week/ month include user run this report.
- Create FOR loop all changes result:
- Each change open TABLE_WORKFLOW
- Get value ATT_WORKFLOW_SIGNOFF_USER
- Check if Sign Off User is the same as user run this report?
- YES- read ATT_WORKFLOW_SIGNOFF_COMMENTS and continue to next workflow.
- NO- continue to next row.
You need decide what you do when you have more than one cycle for the change. Did you read comments only from last cycle or you read all comments from all cycles.
IF you have more questions please feel free to ask,
Thanks a lot for your help. I got the comment through API , But I have the new question,
the originally I want to generate the last week release change’s comment for end user,
they tell me their request is last week through him/her change comment, not last week release change,
So currently I have no idea how to implement it.
and the sql solution I will try to join these table….Thanks
- Search any process is not release that user is reviewer.
- For each process you need find comment of user and check if “Local Client Time” is during last week or not,