CDR Tickets

Issue Number 4967
Summary Date range filter for Health Professional Glossary Terms report
Created 2021-04-06 11:54:22
Issue Type New Feature
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2021-05-06 04:44:29
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.288358
Description

Please modify the Health Professional Glossary Terms report to include a date range filter so that users can specify to get results that fall within the date range selected. Please use the TermNameStatusDate and TranslatedNameStatusDate elements for this feature.

Comment entered 2021-04-06 14:11:43 by Kline, Bob (NIH/NCI) [C]

The TermNameStatus and TranslatedTermNameStatus elements have no date children or attributes. Did you perhaps mean the TermNameStatusDate and TranslatedNameStatusDate elements?

Comment entered 2021-04-06 14:27:51 by Osei-Poku, William (NIH/NCI) [C]

Yes, please use the TermNameStatusDate and {{TranslatedNameStatusDat}}e elements. Those were the elements I had it mind and thanks for catching that. I will correct the original request.

Comment entered 2021-05-05 14:23:14 by Kline, Bob (NIH/NCI) [C]

Implemented on CDR DEV.

Comment entered 2021-05-05 17:24:13 by Osei-Poku, William (NIH/NCI) [C]

The report is not retrieving any data for me regardless of how far back I go. Is it because the terms need to be re-indexed or I have to make changes on DEV in order to see results?

Comment entered 2021-05-05 17:51:35 by Kline, Bob (NIH/NCI) [C]

, when you report a problem, it would be helpful if you would include steps for reproducing that problem.

Comment entered 2021-05-05 18:16:59 by Osei-Poku, William (NIH/NCI) [C]

Sure. Will do. I was still testing but I thought that what I considered to be the problem had to do with re-indexing so I didn't bother to include details. I have attached one search (interface and results from the search) that I expected to see at least one set of results but nothing is showing.  This was for the "English" search. When I change the language to "Spanish" leaving all other options as is (attached interface), the report includes the expected data. Also, when selecting both English and Spanish the report produce the expected data, but not when I select English alone (leaving all other options selected as in the attached screenshot). 

 

Comment entered 2021-05-05 18:54:12 by Kline, Bob (NIH/NCI) [C]

I was looking in the wrong place for the English status. I'll fix this tomorrow.

Comment entered 2021-05-06 04:44:04 by Kline, Bob (NIH/NCI) [C]

The document structure is a bit surprising. The status and status date for a Spanish name are inside the TranslatedName block for the specific name string. But there is no status or date inside the block for the English name. Instead there is a TermNameStatus element and a TermNameStatusDate element outside the block for the English name, at the top level for the document. Presumably that status date is what I look at for the English name, but I wouldn't be very surprised if some CDR users get confused and think that the values in those elements refer to the status for the whole document, not just the English name.

Another complication is that for this report some of the filtering is done on the concept documents and some of the filtering is done on the name documents.

I think I've got it working correctly now, but it's tricky enough that you should test very carefully.

Comment entered 2021-05-11 11:53:14 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV. Thanks!

Comment entered 2021-06-04 09:32:11 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Comment entered 2021-06-23 10:48:34 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thanks!

Attachments
File Name Posted User
HP terms report _ no results_1.PNG 2021-05-05 18:08:23 Osei-Poku, William (NIH/NCI) [C]
HP terms report _ no results.PNG 2021-05-05 18:08:23 Osei-Poku, William (NIH/NCI) [C]
image-2021-05-05-17-49-58-532.png 2021-05-05 17:49:59 Kline, Bob (NIH/NCI) [C]
image-2021-05-05-17-50-23-300.png 2021-05-05 17:50:23 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.001869