Re: [Gnumed-devel] Measurement workflows

[Karsten Hilbert]

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