Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Purpose

This procedure is designed to expire previously created Request for Medication request after ended time-life in ACTIVE status.

Procedure logic for transition

For info - status charts: Medication_request

Get list Medication request

Code Block

language	sql

SELECT * FROM requests_for_medication_request RMR
    WHERE RMR.status == NEW
        AND RMR.expiry_to <= current_date()

SELECT * FROM requests_for_medication_request RMR
    WHERE RMR.status == NEW
        AND RMR.expiry_to <= current_date()

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