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)

Add Comment
4 Answer(s)

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

Agile Talent Answered on June 16, 2015.
Add Comment

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,

Agile Angel Answered on June 16, 2015.
Add Comment

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

Agile User Answered on June 16, 2015.
Add Comment
  • 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,
Agile Angel Answered on June 16, 2015.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.