Create a Change report for current pending approval(sysaproval_group)

[Anuran Sen]

Create a Change report for current pending approval(sysaproval_group). Below condition should be applied on the report.

• Change State  = Assess AND 
• sysapproval_group state is Requested
• Planned Start Date = Today AND 
• Planned Start Date = next 2 weeks

The report should contain below fields.

• Change Number
• Change State
• Planned Start Date 
• Planned End Date
• Approval Groups (sysapproval_group)
• sysapproval_group state = Requested

[Onkar Pandav]

Hi,

Create "List" type report for this and try with below condition. (Refer screen shot).

Let me know if it helps.

[Anuran Sen]

Thanks Onkar for the update.

I need the report extract that contains Approval Group names associated to Change ticket with state = Assess and Approval = Requested.

Example CH0000123 will contain multiple groups for approval. 

CH0000123 - Infrastructure Approval Group

CH0000123 - Security Approval Group

Please expedite.

[Onkar Pandav]

Ok Anuran.

If you try reporting on "sysapproval_group" then there are no planned start date & end date fields. You can achieve what you said in your last reply but no planned start or end date. Refer below screen shot.

So, I suggest you to go with Database view where you can join two tables "change_request" and "sysapproval_group". You can then apply filters on planned start date & end date fields.

Give it a try.

Mark helpful/correct based on impact.