Get Catalog task number in the report for Approval (sysapproval_approver)

RahimKhanM
Tera Contributor

‎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

0 Helpfuls
  • 440 Views
2 REPLIES 2

J Siva
Tera Sage

‎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

 

Nikhil Bajaj9
Tera Sage

‎06-15-2025 06:24 AM

Hi @RahimKhanM ,

 

Try Database view [to get data from 2 or more tables]

 

Regards,

Nikhil Bajaj

Please appreciate my efforts, help and support extended to you by clicking on – “Accept as Solution”; button under my answer. It will motivate me to help others as well.
Regards,
Nikhil Bajaj