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

[Karsten Hilbert]

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

SELECT *
FROM audit.log_message_inbox
WHERE
        fk_staff = <staff ID of provider>
                AND
        audit_action = 'DELETE'
                AND
        audit_when > (now() - '7 days'::interval)
ORDER BY
        <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.

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