Need to fetch Knowledge article number in sysapproval_approver Table for Approving field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Need to get KA number to easily understand the approvals the users are receiving
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Hi @priyanka Ganta ,
Where do you want to fetch the KB number from? If an approval is in the Article , by default, it appears in the Approving field.
Am I missing something here?
ex:
Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
@priyanka Ganta , As mentioned by @Hemanth M1
The KB article number is always present on the approval table . Do you need any other workaround or if you have any other requirements related to this ?
Regards,
Nayan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Hi @priyanka Ganta ,
When you open any record in draft state and click on Publish button, then you can see new record is created with review state in that record your can see the approval is there
That user is Knowledge base user
You can also find the approval record in sysapproval_approver table
Please mark my answer correct and helpful if this works for you
Thanks and Regards,
Sarthak
