How to display the fields of the sn_vul_change_approval table on the list screen of "My Approvals".

nagaryu
Tera Contributor

When I open the Requested record from "Vulnerability Response> My Approvals", I see "Summary of Item being approved / Vulnerability State Change Approval" at the bottom of the form.

Therefore, I would like to display the "Approval name" and "Requested by" of the fields displayed in the above Summary on the list list screen that is displayed when I click My Approvals. Is this possible?

In addition, since the column "Approving" of "My Approvals" seems to refer to the sn_vul_change_approval table, I thought that it could be displayed by dot work, but in List Layout, "Approval name" and "Requested by" in dot work, could not be displayed.

Best regards.

1 ACCEPTED SOLUTION

Hi,

sn_vul_change_approval table doesn't extend task so you cannot dot walk from the Approval for field.

You cannot dot walk from document id field.

Only way is to create custom field on sysapproval_approver table but please check with your ServiceNow account representative on how many custom fields you can create on OOB table

It varies based on subscription.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

13 REPLIES 13

it worked for me

Please check scope issue.

that field seems to be on Vulnerability scope and the list layout would be in global scope

Ensure you are in correct scope

Even if you select Vulnerability scope and try to configure the list layout; you would require to create new view in that scope for list and add the correct field name

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Thank you for your many replies.

I changed to the Vulnerability Response scope and created the view, but unfortunately it didn't change.

By the way, for the first time, I learned that the Type of the "Approver" field in this sysapproval_approver table is "Document ID".

And when I referred to other articles, I got the information that dot work cannot be used.

For scripts such as Business Rules, I saw various articles as a workaround, but I could not find a way to display columns on the list list screen.

I came up with the idea of "creating a custom field in the sysapproval_approver table, and then retrieving and displaying the field in the Document ID in the Business Rules when the record is inserted".

Is there any other better way?

Hi,

sn_vul_change_approval table doesn't extend task so you cannot dot walk from the Approval for field.

You cannot dot walk from document id field.

Only way is to create custom field on sysapproval_approver table but please check with your ServiceNow account representative on how many custom fields you can create on OOB table

It varies based on subscription.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

I understand how it works.
I will consider how to do it.
Thank you very much.