On 2014-12-11, at 3:29 PM, Karsten Hilbert <address@hidden> wrote:
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.
After I search / activate Kirk and after the default plugin (in my case demographics) loads, I receive an alert (see screenshot 1) whose meaning about 0:60 is unclear to me because it appears that document's been there for some time.
If I then select the Documents plugin,
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
)
;
The above query lacked a space character to permit assigning alias b2 after which yielded:
pk_patient | pk_obj | seq_idx | size | date_generated | type | l10n_type | ext_ref | episode | doc_comment | obj_comment | filename | pk_intended_reviewer | reviewed | reviewed_by_you | reviewed_by_intended_reviewer | pk_doc | pk_type | pk_encounter | pk_episode | pk_health_issue | xmin_doc_obj
------------+--------+---------+--------+-------------------------------+----------------+----------------+---------+------------+-------------+-------------+--------------------------------------------------------------------------------------------------------------------------+----------------------+----------+-----------------+-------------------------------+--------+---------+--------------+------------+-----------------+--------------
12 | 158 | 1 | 188330 | 2013-01-23 15:31:00.669669-08 | Correspondence | Correspondence | | prevention | | | /var/folders/vq/dqn33vzx2_j3ktqct7xtm5kw0000gq/T/gnumed/gm-3k2zsx/gm-L-Template-OYK0Mt-instance.pdf | 4 | f | f | f | 103 | 58 | 817 | 49 | | 5381
12 | 159 | 2 | 12108 | 2013-01-23 15:31:00.669669-08 | Correspondence | Correspondence | | prevention | | | /var/folders/vq/dqn33vzx2_j3ktqct7xtm5kw0000gq/T/gnumed/gm-3k2zsx/gm-L-Template-OYK0Mt/gm-L-Template-OYK0Mt-instance.tex | 4 | f | f | f | 103 | 58 | 817 | 49 | | 5381
(2 rows)
------------+--------+---------+--------+-------------------------------+----------------+----------------+---------+------------+-------------+-------------+--------------------------------------------------------------------------------------------------------------------------+----------------------+----------+-----------------+-------------------------------+--------+---------+--------------+------------+-----------------+--------------
12 | 158 | 1 | 188330 | 2013-01-23 15:31:00.669669-08 | Correspondence | Correspondence | | prevention | | | /var/folders/vq/dqn33vzx2_j3ktqct7xtm5kw0000gq/T/gnumed/gm-3k2zsx/gm-L-Template-OYK0Mt-instance.pdf | 4 | f | f | f | 103 | 58 | 817 | 49 | | 5381
12 | 159 | 2 | 12108 | 2013-01-23 15:31:00.669669-08 | Correspondence | Correspondence | | prevention | | | /var/folders/vq/dqn33vzx2_j3ktqct7xtm5kw0000gq/T/gnumed/gm-3k2zsx/gm-L-Template-OYK0Mt/gm-L-Template-OYK0Mt-instance.tex | 4 | f | f | f | 103 | 58 | 817 | 49 | | 5381
(2 rows)
… as opposed to the query in Karsten's followup email, which yielded
gnumed_v19=> select * from blobs.v_obj4doc_no_data where reviewed = False;
pk_patient | pk_obj | seq_idx | size | date_generated | type | l10n_type | ext_ref | episode | doc_comment | obj_comment | filename | pk_intended_reviewer | reviewed | reviewed_by_you | reviewed_by_intended_reviewer | pk_doc | pk_type | pk_encounter | pk_episode | pk_health_issue | xmin_doc_obj
------------+--------+---------+--------+-------------------------------+----------------------------+----------------------------+---------+-----------------------------------------------+-------------+-------------+--------------------------------------------------------------------------------------------------------------------------+----------------------+----------+-----------------+-------------------------------+--------+---------+--------------+------------+-----------------+--------------
14 | 5 | 1 | 135814 | 2011-05-10 00:23:39.446398-07 | cumulative patient profile | cumulative patient profile | | Contrast-related | | | /var/folders/rR/rRhuX5jzF8WCKfgoTie3Zk+++TQ/-Tmp-/gnumed/gm-Ndzmj_/gm-L-Template-v2PqlZ-instance.pdf | 1 | f | f | f | 4 | 39 | 45 | 11 | 10 | 5381
14 | 20 | 1 | 168466 | 2011-08-06 20:36:09.881737-07 | cumulative patient profile | cumulative patient profile | | administration | | | /var/folders/rR/rRhuX5jzF8WCKfgoTie3Zk+++TQ/-Tmp-/gnumed/gm-bhSwjK/gm-L-Template-EyiqLM-instance.pdf | 1 | f | f | f | 15 | 39 | 193 | 13 | | 5381
14 | 21 | 1 | 187335 | 2011-08-06 23:30:15.181758-07 | cumulative patient profile | cumulative patient profile | | Needs multiple problems sorted pending nephro | | | /var/folders/rR/rRhuX5jzF8WCKfgoTie3Zk+++TQ/-Tmp-/gnumed/gm-rdOb5j/gm-L-Template-3DUpkd-instance.pdf | 1 | f | f | f | 16 | 39 | 193 | 12 | 11 | 5381
12 | 158 | 1 | 188330 | 2013-01-23 15:31:00.669669-08 | Correspondence | Correspondence | | prevention | | | /var/folders/vq/dqn33vzx2_j3ktqct7xtm5kw0000gq/T/gnumed/gm-3k2zsx/gm-L-Template-OYK0Mt-instance.pdf | 4 | f | f | f | 103 | 58 | 817 | 49 | | 5381
12 | 159 | 2 | 12108 | 2013-01-23 15:31:00.669669-08 | Correspondence | Correspondence | | prevention | | | /var/folders/vq/dqn33vzx2_j3ktqct7xtm5kw0000gq/T/gnumed/gm-3k2zsx/gm-L-Template-OYK0Mt/gm-L-Template-OYK0Mt-instance.tex | 4 | f | f | f | 103 | 58 | 817 | 49 | | 5381
(5 rows)
pk_patient | pk_obj | seq_idx | size | date_generated | type | l10n_type | ext_ref | episode | doc_comment | obj_comment | filename | pk_intended_reviewer | reviewed | reviewed_by_you | reviewed_by_intended_reviewer | pk_doc | pk_type | pk_encounter | pk_episode | pk_health_issue | xmin_doc_obj
------------+--------+---------+--------+-------------------------------+----------------------------+----------------------------+---------+-----------------------------------------------+-------------+-------------+--------------------------------------------------------------------------------------------------------------------------+----------------------+----------+-----------------+-------------------------------+--------+---------+--------------+------------+-----------------+--------------
14 | 5 | 1 | 135814 | 2011-05-10 00:23:39.446398-07 | cumulative patient profile | cumulative patient profile | | Contrast-related | | | /var/folders/rR/rRhuX5jzF8WCKfgoTie3Zk+++TQ/-Tmp-/gnumed/gm-Ndzmj_/gm-L-Template-v2PqlZ-instance.pdf | 1 | f | f | f | 4 | 39 | 45 | 11 | 10 | 5381
14 | 20 | 1 | 168466 | 2011-08-06 20:36:09.881737-07 | cumulative patient profile | cumulative patient profile | | administration | | | /var/folders/rR/rRhuX5jzF8WCKfgoTie3Zk+++TQ/-Tmp-/gnumed/gm-bhSwjK/gm-L-Template-EyiqLM-instance.pdf | 1 | f | f | f | 15 | 39 | 193 | 13 | | 5381
14 | 21 | 1 | 187335 | 2011-08-06 23:30:15.181758-07 | cumulative patient profile | cumulative patient profile | | Needs multiple problems sorted pending nephro | | | /var/folders/rR/rRhuX5jzF8WCKfgoTie3Zk+++TQ/-Tmp-/gnumed/gm-rdOb5j/gm-L-Template-3DUpkd-instance.pdf | 1 | f | f | f | 16 | 39 | 193 | 12 | 11 | 5381
12 | 158 | 1 | 188330 | 2013-01-23 15:31:00.669669-08 | Correspondence | Correspondence | | prevention | | | /var/folders/vq/dqn33vzx2_j3ktqct7xtm5kw0000gq/T/gnumed/gm-3k2zsx/gm-L-Template-OYK0Mt-instance.pdf | 4 | f | f | f | 103 | 58 | 817 | 49 | | 5381
12 | 159 | 2 | 12108 | 2013-01-23 15:31:00.669669-08 | Correspondence | Correspondence | | prevention | | | /var/folders/vq/dqn33vzx2_j3ktqct7xtm5kw0000gq/T/gnumed/gm-3k2zsx/gm-L-Template-OYK0Mt/gm-L-Template-OYK0Mt-instance.tex | 4 | f | f | f | 103 | 58 | 817 | 49 | | 5381
(5 rows)
-- JIm
