CDR Tickets

Issue Number 3732
Summary [Genetic Professional] Finding better ways of selecting family syndromes
Created 2014-02-24 12:47:09
Issue Type New Feature
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2014-03-03 07:18:12
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.118768
Description

When entering new or updating existing family syndromes for GP Documents, it has become time consuming to go through a long list of Genetics syndromes in order to select only the ones that pertain to the GP records, as more and more terms are typed as genetic conditions but are not used for the GP documents. This means that we have to always go through a long list of terms to select the ones we need. We retrieve the list by typing %Genetic%condition% into the CTRL + Enter macro search field and going through the results to select the ones we need. The macro retrieves all terms that have the semantic type of Genetic Condition. However, we want to be able to retrieve just the set of syndromes that are assigned to GP professionals.

We discussed the possibility of adding a new element to the Term document that we will use to tag the set of syndromes we use for the GP persons. We also talked about the alternative of using an attribute on the display name as an example.

Comment entered 2014-02-28 16:00:35 by Kline, Bob (NIH/NCI) [C]

Is this the set you want to be selecting from?

Comment entered 2014-03-03 07:18:12 by Kline, Bob (NIH/NCI) [C]

I have modified the CDR server and the DLL for XMetaL so that the links available for the FamilialCancerSyndrome element are taken from the set returned by a custom SQL query based on the one used to populate the GP mailer form:

  SELECT DISTINCT d.id, d.title
    FROM document d
    JOIN query_term t
      ON t.doc_id = d.id
    JOIN query_term s
      ON s.doc_id = t.doc_id
     AND LEFT(s.node_loc, 8) = LEFT(t.node_loc, 8)
   WHERE t.path = '/Term/MenuInformation/MenuItem/MenuType'
     AND s.path = '/Term/MenuInformation/MenuItem/MenuStatus'
     AND s.value = 'Online'
     AND t.value = 'Genetics Professionals--GeneticSyndrome'
     AND d.ditle LIKE ?
ORDER BY 2

  • R12406 /trunk/XMetaL/DLL/CdrUtil.cpp

  • R12406 /trunk/XMetaL/DLL/CdrUtil.h

  • R12406 /trunk/XMetaL/DLL/Commands.cpp

  • R12406 /trunk/XMetaL/DLL/Commands.h

  • R12406 /trunk/XMetaL/DLL/EditElement.cpp

  • R12406 /trunk/XMetaL/DLL/EditElement.h

  • R12406 /trunk/XMetaL/DLL/cdr.idl

  • R12409 /trunk/Server/CdrReport.cpp

Ready for user testing on DEV.

Comment entered 2014-03-03 09:06:58 by Osei-Poku, William (NIH/NCI) [C]

Yes. That is the set we want to select from.

Comment entered 2014-03-04 14:21:07 by Osei-Poku, William (NIH/NCI) [C]

I am able to see all the syndromes when I do a wild card search. But I am only able to select one syndrome at a time. It won't let me select all or more than one syndrome at a time.

Comment entered 2014-03-04 17:53:15 by Kline, Bob (NIH/NCI) [C]

Try it now.

  • R12416 /trunk/XMetaL/DLL/EditElement.cpp

Comment entered 2014-03-05 10:12:33 by Osei-Poku, William (NIH/NCI) [C]

It's working as expected. Thank you!

Comment entered 2014-03-05 10:12:59 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV.

Comment entered 2014-04-15 15:42:20 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA.

Comment entered 2014-05-01 10:54:10 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thank you!

Attachments
File Name Posted User
sdlm-20140228155551.xls 2014-02-28 16:00:35

Elapsed: 0:00:00.001526