[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:34:56 +0100 |
User-agent: |
Mutt/1.5.23 (2014-03-12) |
On Fri, Dec 12, 2014 at 12:29:05AM +0100, Karsten Hilbert wrote:
> > 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
> )
> ;
In contrast to:
select * from blobs.v_obj4doc_no_data where reviewed = False;
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346