[Top][All Lists]

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

Re: [Gnumed-bugs] Inbox failure to detect some (?) unreviewed documents

From: Karsten Hilbert
Subject: Re: [Gnumed-bugs] Inbox failure to detect some (?) unreviewed documents
Date: Fri, 12 Dec 2014 00:29:05 +0100
User-agent: Mutt/1.5.23 (2014-03-12)

On Thu, Dec 11, 2014 at 07:19:19PM +0000, Jim Busser wrote:

> When I search and activate Kirk (pk id = 12), I am warned by GNUmed that 
> there exists unreviewed documents for Kirk.

Please specify which way you are warned by GNUmed.

> This makes me wonder whether there is a state or attribute of this 
> "unreviewed" document that the inbox algorithm is failing to detect.
> What can I do (what query result might I attempt) that could give more 
> information?

select * from blobs.v_obj4doc_no_data b1
        pk_patient = PATIENT_ID
        not exists (
                select 1 from blobs.reviewed_doc_objsb2
                where b2.fk_reviewed_row = b1.pk_obj

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]