[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] what happened to the GNUmed developers ?
Date: Fri, 1 Dec 2006 14:30:48 +0100
User-agent: Mutt/1.5.13 (2006-08-11)

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 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:

                clin.clin_narrative, dem.v_basic_person
                ... 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.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]