Purpose
This procedure (automatic schedule task) is designed to expire previously created Medication request request after lifetime ends in status='NEW'.
Process configuration
Name | Description | Format | Default value |
|---|---|---|---|
MEDICATION_REQUEST_REQUEST_SCHEDULE | How often to perform this task | Cron Format | `* * * * *` |
MEDICATION_REQUEST_REQUEST_EXPIRATION | Medication request request lifetime period | Minutes | 30 |
Job logic
Read MEDICATION_REQUEST_REQUEST_EXPIRATION parameter value
Fetch records from `medication_request_requests`, where:
status = 'NEW'
inserted_at < NOW() - MEDICATION_REQUEST_REQUEST_EXPIRATION
Update status for all records:
status = EXPIRED
updated_by = SYSTEM_USER
updated_at = timestamp