Get Catalog task number in the report for Approval (sysapproval_approver)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-15-2025 05:11 AM
I am trying to create a report on the Approver (sysapproval_approver) table but unable to pull the Catalog task number in the report. Tried getting it via dot walking Approval for+ but it is not showing the number.
This particular catalog item has only 1 task per RITM. Approval is on RITM record
Is there a way to get the Task number directly in Approval table without database view.
The ask is to show the state Approver + Approval state + RITM + Catalog task number via Report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-15-2025 05:21 AM
Hi @RahimKhanM
It's not possible to get the SC task number without any customisation or database view.
Database view is the best approach to meet your requirement.
Regards,
Siva
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-15-2025 06:24 AM
Hi @RahimKhanM ,
Try Database view [to get data from 2 or more tables]
Regards,
Nikhil Bajaj
Regards,
Nikhil Bajaj