Page Comparison

Table of Contents

Status

...

This procedure (Automatic schedule task) is designed to expire previously created Medication request Request after ended time-life in NEW statuslifetime ends in status='NEW'.

Procedure logic for transition

1. For info - status charts: Medication request Request Status Chart

2. Get list of Medication request requests

   Code Block
   language sql
   SELECT * FROM medication_request_requests RMR WHERE RMR.status == NEW AND RMR.expired_at <= current_date()

   
   

3. Update (Set values) Request for Medication request Request
   1. status  =  EXPIRED
   2. updated_by = user_id
   3. updated_at = timestamp