How to create a report on RITM where Stage is waiting for approval from more than 2 days

[zee15]

Hi,

Is it possible to create a report on RITM (sc_req_item) table, where RITM stage is "Awaiting for approval" for more than 2 days?

[Mark Manders]

You can use related list conditions. When an approval is created, the stage changes (OOB, at least). So that means that you can query all RITMs on 'stage = awaiting approval' with a related list condition of 'approval.sys_created_on > 2 days ago'.