Re: [Gnumed-devel] GNUmed 0.9.0 released

[Karsten Hilbert]

On Thu, Apr 14, 2011 at 07:05:21AM -0700, Jim Busser wrote:

> >> That's because you likely don't have a *tag* the
> >> description of which is "1" ;-)
> > 
> > For further clarification you would want to say:
> > 
> >     WHERE vit.l10n_description = 'mobility impairment'
> > 
> > or some such.
> 
> The tag window has a column #
> 
> What search term is required to represent that entity / field so as to find 
> patients for whom a tag (not tag comment) is of interest?

The above *is* the search for a tag. The tag itself is
*named* "mobility impairment" (and *shows* a wheelchair).

A patient-specific comment on that tag might be:

        previously used walking stick, wheelchairs since
        11/2010, can still stand up

Once a list of patients is found, double-click any row to go
to that patient.

Oooh, wait, you want to search for the primary key of the tag ?

Do this:

        WHERE vit.pk_tag_image = <the value of ref.tag_image.pk you are after>

or

        WHERE vit.pk_tag_image IN (1, 2, 3, ...)

to search of a list of tags by their primary key.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346