1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| SELECT J.Id,
j.TIMESTAMP,
j.Status,
j.version,
j.Environment,
Extractvalue(J.Questionnaire,'/Response/Patient/URGNUM') URGNUM,
Extractvalue(J.Questionnaire,'/Response/Patient/DAYURGIN') || '/' || Extractvalue(J.Questionnaire,'/Response/Patient/MONTHURGIN') || '/' || Extractvalue(J.Questionnaire,'/Response/Patient/YEARURGIN') DTEDEB,
Extractvalue(J.Questionnaire,'/Response/Patient/HOURURGIN') || ':' || Extractvalue(J.Questionnaire,'/Response/Patient/MINURGIN') HREDEB,
Extractvalue(J.Questionnaire,'/Response/Patient/PATNUM') PATNUM,
(Select Left(Nom,20) || ' ' || Left(Prenom,20) From Patients Where Numnat = Extractvalue(J.Questionnaire,'/Response/Patient/PATNUM')) Patient,
(Select numpat From Patients Where Numnat = Extractvalue(J.Questionnaire,'/Response/Patient/PATNUM')) NUMPAT
FROM ureg.Journal J
WHERE TIMESTAMP between '06/02/2015' and '07/02/2015'
ORDER BY to_date(Extractvalue(J.Questionnaire,'/Response/Patient/DAYURGIN') || '/' || Extractvalue(J.Questionnaire,'/Response/Patient/MONTHURGIN') || '/' || Extractvalue(J.Questionnaire,'/Response/Patient/YEARURGIN'),'dd/mm/yyyy'),
to_date(Extractvalue(J.Questionnaire,'/Response/Patient/HOURURGIN') || ':' || Extractvalue(J.Questionnaire,'/Response/Patient/MINURGIN'),'HH24:MI') |
Partager