Hi,
I am seeing values that I do not understand displayed in Waiting list plug in.
1) What will induce Waiting list dates (and waiting times) to refresh? Activating a new patient (in search) and coming back to the plugin did not see to achieve it.
2) Displays of waiting time -- are these supposed to be
now() - clin.waiting_list.registered
??
See attached a screen shot. The displayed waiting time of
12 03:50
makes no sense to me, because the patient was registered 348 days 03:50:55.30 ago. Was somehow the
348 days
converted to 12 months, with the hours left the same, resulting in the strange combined output? Similarly what is displayed as
20 22:20
corresponds to a registered date/time of 325 days 22:20:21.27 ago. Again, the 22:20 is correct but where did the "leading" 20 come from?
Next, the values and correspondences are:
15 03:09 <==> 320 days 03:09:07.549
8 02:53 <==> 282 days 02:53:28.53
8 02:14 <==> 282 days 02:14:58.16
...
17 03:02 <==> 230 days 02:02:35.26
Here is the query that I used in psql to display the comparitor data:
select w.pk, w.urgency, w. area, n.lastnames, n.firstnames,
w.comment, now() - w.registered Waiting_time from clin.waiting_list w
inner join dem.identity i on w.fk_patient = i.pk
inner join dem.names n on i.pk = n.id_identity where n.active is true ;