Re: [Gnumed-devel] GNUmed documents: about "parts"

[Karsten Hilbert]

On Fri, Jan 25, 2008 at 03:39:33PM -0800, James Busser wrote:

> Shall "Intended reviewer" also be red?
Yes, done.

> Can this field support a phrasewheel that would offer, in its dropdown, 
> the staff who are of role "doctor"?
Funnily, it already IS a phrasewheel. It matches with the
following query:

        select
                pk_staff,
                short_alias || ' (' || coalesce(title, '') || firstnames || ' ' 
|| lastnames || ')',
                1
        from dem.v_staff
        where
                short_alias || ' ' || firstnames || ' ' || lastnames || ' ' || 
db_user %(fragment_condition)s

IOW, typing any of the alias, the database user, the first-
or lastname of a staff member should bring forth matches. It
does work here, too.

It is not currently constrained on role, but we don't really
support roles yet (id est they are hardcoded to "doctor").

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346