[CORE-309] Add includeHiddens attribute for all calls made to the TABLE_ACCESS table Created: 31/May/18  Updated: 23/Jan/19  Resolved: 23/Jan/19

Status: Closed
Project: i2b2 Core Software
Component/s: None
Affects Version/s: None
Fix Version/s: 1.7.11

Type: Improvement Priority: Major
Reporter: Janice Donahoe Assignee: Reeta Metta
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Rank: 0|i003zr:
Participant/s:

 Description   
Currently when the Ontology cell queries the TABLE_ACCESS table there is no way to include or exclude hidden records. When multi-fact table is setup, queries against TABLE_ACCESS have taken an extended amount of time and will often time out.

The option is to add the includeHiddens attribute to all service calls (queries) made to the TABLE_ACCESS table. The boolean value would be:

        true = hiddens will be included
        false = hiddens will not be included in the search


By default hiddens will not be included in searches ( default="false" ) by the client.

However, the CRC will default hiddens = true on its internal ONT lookups. This is because hidden terms can be queryable.

This primarily applies to operation getCodeInfo

 Comments   
Comment by Lori Phillips [ 05/Dec/18 ]
To test:

Change an existing category in table_access to hidden. (e.g.ICD10 Diagnoses)
Do a Find by code search for a Diagnoses. I02 Coding system = ICD10
 (Rheumatic chorea) Code should not be found.

Open options and check off "Show hidden Terms"
Search again. Term should be found.
Generated at Fri Mar 29 11:54:46 UTC 2024 using Jira 8.20.11#820011-sha1:0629dd8d260e3954ece49053e565d01dabe11609.