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.

[Community Alums · Accepted solution]

Both database view and relation list condition will work. For relation list condition, try below.

[Jennifer Nguye2]

Thanks for the help! Will be creating the database view