Re: [Gnumed-devel] what happened to the GNUmed developers ?

[Karsten Hilbert]

On Sat, Dec 02, 2006 at 12:04:41AM +1100, syan tan wrote:

> I was able to contribute to a peer education discussion list using
> gnumed today; someone mentioned an uncommon condition, and
> I was able to locate a similiar case using gnumed ,

:-)))

> by doing
> a search on clin.clin_narrative ilike (case-insensitive like) '%<search
> word1>%'  and clin.clin_narrative ilike '%<search word2>%' , 
> and then backtracking to the identity.pk and the dem.names.id_identity.
A few points for your convenience:

- you might want to use the PG regex operators ~ and ~*
  (insensitive) for increased matching power - OTOH they
  might be somewhat slower

- a join might help:

        select
                ...
        from
                clin.clin_narrative, dem.v_basic_person
        where
                ... and
                clin.clin_narrative.fk_patient = dem.v_basic_person.pk_identity

  That'll give you the patient right away.

But you knew that.

> Very useful  ; probably could do it using out native emr, but
> wouldn't have been < 10 seconds , as with gnumed.
Very nice :-)

The first non-Hilbert real-live report of GNUmed being
useful that I know of.

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