How to pull record from sysapproval_approver table which are older than 5 days but not older than 10
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2025 08:47 AM
I need to pull record from sysapproval_approver table, which is older than 5 days but not older than 10 days and it is still in 'requested' state using lookup record. Below is the screen shot which I am using however it not giving desired result. Can some please help me to fetch record which falls between 5 to 10 days older from created date and not approved. I need to trigger reminder notification for these record to approver.
Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-03-2025 07:56 AM
anyhow you are doing complex scripting in flow with flow variables etc
Not all requirements can be achieved using flow.
There are some situations which are complex and you need to use flow.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader