[Top][All Lists]

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

Re: Feedback Re: [Gnumed-devel] GNUmed Release 0.6.rc1

From: Karsten Hilbert
Subject: Re: Feedback Re: [Gnumed-devel] GNUmed Release 0.6.rc1
Date: Tue, 1 Dec 2009 21:02:26 +0100
User-agent: Mutt/1.5.20 (2009-06-14)

On Tue, Dec 01, 2009 at 08:02:17AM -0800, Jim Busser wrote:

> 1) what would be the select from query to fetch, from the
> inbox audit table, the messages deleted within the past 7
> days, ordered by recency of last-modified

FROM audit.log_message_inbox
        fk_staff = <staff ID of provider>
        audit_action = 'DELETE'
        audit_when > (now() - '7 days'::interval)
        <audit_when / orig_when / modified_when> DESC

> and could that be added to the built in queries, as say
>       find inbox messages deleted in past 7 day

Sure, but not now.

>  2) what do you think about a proposal that in future
> there be added a "reviewed" column to the inbox table, at
> the same time replacing the "deleted" functionality by a
> "reviewed" functionality which, once designated, causes the
> item to be auto-filtered out of view. Then, to assist
> bringing such items back into view (since, despite being
> "reviewed", the message content might have to be consulted)
> adding a checkbox to the right of the radio buttons "show
> reviewed items". A filter search box (like Waitlist) could
> facilitate finding the item. Lastly, to cut down
> accumulation of reviewed items, auto deleting them after 7
> days (which still causes them to be copied into the audit
> table)

No problem with that.

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]