[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Measurement workflows
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Measurement workflows |
Date: |
Tue, 9 Jul 2013 15:50:18 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
On Mon, Jul 08, 2013 at 06:22:57PM +0000, Jim Busser wrote:
> (3) I can assign a different lab (in case it was not inhouse)
>
> --> can this have phrasewheel support?
It already does. It doesn't provide matches, however. You
found a bug:
2013-07-09 15:43:50 ERROR gm.db
(/home/ncq/Projekte/gm-git/gnumed/gnumed/Gnumed/pycommon/gmPG2.py::run_ro_queries()
#1132): query failed: [
SELECT DISTINCT ON (list_label)
pk AS data,
unit || ' (' || organization || ')' AS field_label,
unit || ' @ ' || organization AS list_label
FROM clin.v_test_orgs
WHERE
unit ILIKE '%%'
OR
organization ILIKE '%%'
ORDER BY list_label
LIMIT 50]
2013-07-09 15:43:50 ERROR gm.db
(/home/ncq/Projekte/gm-git/gnumed/gnumed/Gnumed/pycommon/gmPG2.py::run_ro_queries()
#1135): PG error code: 42703
2013-07-09 15:43:50 ERROR gm.db
(/home/ncq/Projekte/gm-git/gnumed/gnumed/Gnumed/pycommon/gmPG2.py::run_ro_queries()
#1137): PG error message: ERROR: column "pk" does not exist
Here's the view:
Sicht »clin.v_test_orgs«
Spalte | Typ | Attribute
------------------+---------+-----------
pk_test_org | integer |
organization | text |
unit | text |
comment | text |
test_org_contact | text |
pk_adm_contact | integer |
pk_med_contact | integer |
pk_org | integer |
category_org | integer |
pk_org_unit | integer |
category_unit | integer |
pk_address_unit | integer |
xmin_test_org | xid |
Hence it needs to be .pk_test_org rather than .pk in that query.
Fixed for 1.3.next.
Note that the phrasewheel operates on units of organizations
of type "Laboratory".
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
screenshot_002.png
Description: PNG image
screenshot_001.png
Description: PNG image