CDR Tickets

Issue Number 4950
Summary Investigate why rejected definitions are not removed from Spanish Genetics dictionary
Created 2021-03-03 11:45:37
Issue Type Bug
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2021-03-03 18:54:00
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.285964
Description

Please investigate why when Spanish Genetics definitions that have been rejected still display on Cancer.gov. 

The affected terms are CDR642015 and CDR302456 and the definition document is CDR622534. The terms are in both dictionaries but only the entry in the Genetics dictionary needed to be blocked and removed from the dictionary so the corresponding definition is marked as rejected. 

It is preferred that when a definition is marked as rejected, the matching terms be removed from the dictionary just as it works for the English terms.

Comment entered 2021-03-03 18:53:32 by Englisch, Volker (NIH/NCI) [C]

The GlossaryTerm vendor filter was checking for the "Rejected" term status but it was checking against all translated definitions.  In other words, if one definition existed with an "Approved" or "Pending" status a definition was displayed regardless of its status.

The following filter has been modified to fix the issue:

The filter changes are ready for review on DEV.  When testing please also include glossary terms using the "English Name (en ingles)" display and those with multiple translated term names.

Comment entered 2021-03-03 18:55:48 by Englisch, Volker (NIH/NCI) [C]

Note:  The CDR has been refreshed yesterday, so the state of the data is close to what's available on PROD.

Comment entered 2021-03-04 12:45:45 by Osei-Poku, William (NIH/NCI) [C]

This appears to be working as expected in pub preview. 

 

 When testing please also include glossary terms using the "English Name (en ingles)" display and those with multiple translated term names.

 

I tested with CDR0000689627 on DEV and it displayed correctly with the (en ingles) label but I am not sure exactly what I should be looking for other than checking to see if the (en ingles) is displayed.

Comment entered 2021-03-04 18:44:05 by Englisch, Volker (NIH/NCI) [C]

The diff reports on QA show that there is still an issue with the output.  It's possible a Spanish term is included in the vendor output if the Spanish name exists but there isn't any definition or the entire definition is within markup.

I will have to make some additional changes to the filter.

Comment entered 2021-03-08 18:39:10 by Englisch, Volker (NIH/NCI) [C]

I've made additional changes to exclude those terms for which there doesn't exist the definition text (or the entire definition text is in mark-up).  

These changes are ready for review on DEV.

Comment entered 2021-03-11 11:47:47 by Osei-Poku, William (NIH/NCI) [C]

I retested this fix and the display looks good. The blocked definition does not show in PP but I assume you would want us to do more testing with different scenarios and not just to look at terms that have been rejected.

Comment entered 2021-03-18 10:43:31 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV. Thanks!

Comment entered 2021-03-18 16:32:03 by Englisch, Volker (NIH/NCI) [C]

We discussed at the status meeting to run a test load on QA but wait until Monday in order to use the latest weekend backup file as the base for the refresh.

Comment entered 2021-03-23 18:53:28 by Englisch, Volker (NIH/NCI) [C]

The filter changes have been setup on QA after yesterday's refresh of the database.  , you can now prepare rejected Genetics terms prior to running a publishing job and glossary dictionary load.

Comment entered 2021-03-24 11:45:22 by Osei-Poku, William (NIH/NCI) [C]

I just realized that you added the dictionary element back into CDR302456, which is the affected definition reported above. I was going to do the same so we can use the same document for testing. I have made it publishable now so it should be good to go. 

Comment entered 2021-03-25 13:11:44 by Englisch, Volker (NIH/NCI) [C]

I've published the two terms on QA and ran a glossary load.

These two links show the output from the publishing job:
https://cdr-qa.cancer.gov/cgi-bin/cdr/ShowCdrDocument.py?Session=guest&Request=Submit&selection_method=id&doc-id=642015&vtype=exported
[
https://cdr-qa.cancer.gov/cgi-bin/cdr/ShowCdrDocument.py?Session=guest&Request=Submit&selection_method=id&doc-id=302456&vtype=exported]

These two links indicate that the rejected definitions were not created in the genetics dictionary: 
https://webapis-qa.cancer.gov/glossary/v1/Terms/genetics/HealthProfessional/es/642015

[
https://webapis-qa.cancer.gov/glossary/v1/Terms/genetics/HealthProfessional/es/302456]

Testing the non-existence of these terms on Cancer.gov would again require for me to adjust a configuration file to have the QA version of Cancer.gov point to the QA dictionary.

Comment entered 2021-03-31 18:32:31 by Englisch, Volker (NIH/NCI) [C]

, please let me know when you would like me copy the modified filter to PROD or if you would like to test once more on QA prior to the copy.

Comment entered 2021-03-31 18:57:48 by Osei-Poku, William (NIH/NCI) [C]

Verified. Please proceed to copy it to PROD. Thanks!

Comment entered 2021-03-31 19:30:23 by Englisch, Volker (NIH/NCI) [C]

The filter changes have been copied to PROD.  After the next weekend publishing job and glossary dictionary refresh the results can be checked.

Comment entered 2021-04-22 13:07:07 by Osei-Poku, William (NIH/NCI) [C]

We have added the dictionary element back into the term document. It will be published on Friday, after which we can close this ticket. Thanks!

Comment entered 2021-04-28 09:54:56 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thanks!

Elapsed: 0:00:00.000615