Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

change the status from work in progress to pending

Aurelijus Raudo
Kilo Contributor

‎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

 

0 Helpfuls
  • 1,602 Views
1 REPLY 1

MuhammadHaA6783
Kilo Sage

‎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

0 Helpfuls