Reporting on Change and approval groups

[Jennifer Nguye2]

Hi,

I have a customer trying to do a report for an audit for Changes and their approval groups. They are trying to report on Changes where Boot = True, State = Authorize, Planned Start = this year and Approval group does not contain ECAB.

We can't dot-walk from the Change table to approvals and using the approval group table we can't get the change records that does not contain an ECAB approval group.

[Narendra Kota]

Try creating a Database view by joining the change and group approval table, then filter the conditions.

Hope this helps.
Mark helpful or correct based on impact.

Thanks.

[Jennifer Nguye2]

Thanks for the help! Will be creating the database view

[dangrady510]

I'm wondering if related list conditions might help https://docs.servicenow.com/bundle/newyork-platform-user-interface/page/use/using-lists-v3/task/crea...

[Jennifer Nguye2]

Hi Dan, been awhile hope you're doing well. Tried using the related list as one of my first options but weirdly we've never been able to get it to work with Change and Approval table. Related lists works in other cases though.