| 80,9 → 80,10 |
|---|
| 'FROM del_observation AS do '. |
| 'WHERE do.ce_utilisateur != 0 '. |
| ' AND do.ce_utilisateur IS NOT NULL '. |
| ' AND (do.mots_cles_texte LIKE "%aDeterminer%" '. |
| ' OR nom_sel IS NULL OR nom_sel = "" '. |
| ' OR nom_ret IS NULL OR nom_ret = "") '. |
| " AND (do.mots_cles_texte LIKE '%aDeterminer%' ". |
| " OR (do.certitude = 'aDeterminer' OR do.certitude = 'A déterminer' OR do.certitude = 'douteux') ". |
| " OR nom_sel IS NULL OR nom_sel = '' ". |
| " OR nom_ret IS NULL OR nom_ret = '') ". |
| ' AND ('. |
| " TO_DAYS($date) - TO_DAYS(do.date_transmission) IN (0, 1) ". |
| " OR TO_DAYS($date) - TO_DAYS(do.date_creation) IN (0, 1) ". |