|
From: | Busser, Jim |
Subject: | Re: [Gnumed-bugs] Inbox failure to detect some (?) unreviewed documents |
Date: | Fri, 12 Dec 2014 01:11:49 +0000 |
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. 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. 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) … 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) -- JIm |
signature.asc
Description: Message signed with OpenPGP using GPGMail
[Prev in Thread] | Current Thread | [Next in Thread] |