Interactive filter for sysapproval_approver table not showing Change Request fields

AG24 · ‎05-18-2023

Hi Team 🙂

I created a report of approvals for Change Requests using the sysapproval_approver table.

I was able to condition for, and show on the report, the Change Owners of the Change Request using the condition/ 'Choose Columns': "Approval For--> Change Request--> Change Owner".

However, when I went to create the interactive filter for this report (so that people can filter by the Change Owner), the Change Owner field doesn't show. That is, when trying to connect the sysapproval_approver to the sys_user table- when I click into the "Approval For" folder it doesn't have the folder for 'Change Request' so I cannot select 'Change Owner' as the field.

Below are the only options available under "Approval For".

Just wondering if I'm missing something or if something needs to be done to add the Change Request fields to the Approval For folder so that they can be selected?

Approval for folder options:

Active

Activity

Activity due

Actual End Date

Actual Start Date

Additional assignee list

Additional comments

Approval

Approval history

Approval set

Assigned to

Assignment group

Business Application

Business duration

Business service

Close notes

Closed

Closed by

Comments and Work notes

Company

Configuration item

Contact type

Contract

Correlation ID

Correlation display

Created

Created by

Delivery plan

Delivery task

Description

Domain

Domain Path

Due date

Duration

E-signature document

E-signature template

Effective number

Escalation

Expected start

Follow up

Follow up attempts

Group list

Impact

KB Article to be created?

Location

Made SLA

Number

Opened

Opened by

Order

Parent

Priority

Reassignment count

Route reason

SLA due

Service offering

Short description

Skills

State

Sys ID