[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-bugs] missing clause WHERE in Happy Birthday list (1 week back a
From: |
Busser, Jim |
Subject: |
[Gnumed-bugs] missing clause WHERE in Happy Birthday list (1 week back and forth from today) |
Date: |
Wed, 27 Nov 2013 23:15:49 +0000 |
What currently appears in my stored queries (Reports plugin) is as follows
-- ============================================
select
to_char(p.dob, 'DD.TMMonth') as birthday,
extract(year from age(dob) - '10 days'::interval) as age,
p.lastnames || ', ' || p.firstnames as name,
p.preferred as preferred_name,
p.pk_identity as pk_patient
from
dem.v_basic_person p
order by
name
-- ============================================
might have undergone accidental modification at my end however I never use it.
If OTOH the "stock" version is defective, it could do with fixing in a fixup.
-- Jim
- [Gnumed-bugs] missing clause WHERE in Happy Birthday list (1 week back and forth from today),
Busser, Jim <=