Re: [Gnumed-devel] GNUmed 0.9.0 released

[Karsten Hilbert]

On Thu, Apr 14, 2011 at 12:18:50AM -0700, Jim Busser wrote:

> On 2011-03-29, at 7:48 AM, Karsten Hilbert wrote:
> 
> >     NEW: implement searchable tags with image/name/comment on patients
> 
> 
> 1) Are the tags to be used for any person (including staff) or do they depend 
> on having the status of "patient"?

My announcement was wrong. You can attach tags to any
demographic record no matter what it is/will be used for.

> 2) Is there a bug in the "Report" plugin search script? When I replace XXX 
> with 1 I cannot find Kirk.
> 
>       WHERE vit.l10n_description = 'XXX'

That's because you likely don't have a script the
description of which is "1" ;-)

This is how tags are defined (as such, not yet related to any person):

        create table ref.tag_image (
                pk serial primary key,
                description text,
                filename text,
                image bytea
        ) inherits (audit.audit_fields);

This meaning that each tag has a description and an image.

Here's how persons are tagged:

        create table dem.identity_tag (
                pk serial primary key,
                fk_identity integer,
                fk_tag integer,
                comment text
        ) inherits (audit.audit_fields);

This lets you add a comment for each tag-attached-to-a-person.

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