change the status from work in progress to pending
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2023 08:34 AM
hi,
need help on building the condition on sc_request table.
when request state changed to Work in progress, after 10 days change status to Pending.
Thank's
Aurelijus
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2023 12:27 PM
Hey Aurelijus Raudo ,
- We need time when the request state changed to Work In Progress. For this, you can create a read-only date field.
- Then, create a Business rule so whenever the state is changed to Work in progress. Populate the date field with the current date.
- Create a Scheduled job (daily), which queries the sc_request records which are in Work in progress state, and then for each record, get the value of the date field and compare it with the current date.
- You can use gs.datediff() to get the duration between dates.
- Then, if the duration is more than 10 days update the record.
If this answers your question, kindly mark this as a Solution.
Regards,
Muhammad Hamza