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

[Karsten Hilbert]

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
where
        pk_patient = PATIENT_ID
                and
        not exists (
                select 1 from blobs.reviewed_doc_objsb2
                where b2.fk_reviewed_row = b1.pk_obj
        )
;

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346