1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| "SELECT
common_order_history.id,
common_order_history.label,
common_order_history.order_control,
common_order_history.order_status,
common_order_history.order_validity_status,
common_order_history.start_date,
common_order_history.start_time,
common_order_history.end_date,
common_order_history.end_time,
common_order_history.urgent,
common_order_history.warning,
common_order_history.common_order_id,
common_order_history.order_set_id,
common_order_history.common_order_group_history_id,
common_order_history.version,
common_order_history.created_date,
common_order_history.last_modified_date
FROM
common_order_history
INNER JOIN order_set ON common_order_history.order_set_id = order_set.id
INNER JOIN patient ON patient.id = order_set.patient_id
WHERE
" + ! "logipren2_etablissement".equals(context.logipren2_filtre_PrescriptionValide) ? "
order_set.history_status = " + context.logipren2_filtre_PrescriptionValide + " AND order_set.ordered_date >= " + TalendDate.formatDate("yyyyMMdd",context.logipren2_filtre_date) : "
1 > 2" |
Partager