create a report for Requested Items grouped by time duration
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 01:55 PM
Is it possible to create a report for Requested Items grouped by Time duration they are open?
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 02:23 PM
Hi @Piyush Dwivedi, yes that would most likely by possible.
Do you need any additional details or just their duration? Some might be paused or pending any blockers...
If you take [task_sla] table into consideration, then you will filter the records for a table [sc_req_item], and then you should be able to get this detail.
Do you aim to have this as a one-timer or to be checked regularly?
———
/* If my response wasn’t a total disaster ↙️ ⭐ drop a Kudos or Accept as Solution ✅ ↘️ Cheers! */
/* If my response wasn’t a total disaster ↙️ ⭐ drop a Kudos or Accept as Solution ✅ ↘️ Cheers! */