CDR Tickets

Issue Number 4947
Summary Modify Media Lists Report
Created 2021-02-24 11:26:18
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2021-04-29 07:08:59
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.285510
Description

Please modify the Media Lists report to add the following two filters as checkboxes. We'd like to be able to select either one or both at the same time.  
*Exclude blocked documents
*Exclude non publishable documents
 
Also, please include the following language options for

  • English

  • Spanish
    When both options are selected, please display the combined results for both languages as is currently displayed in the current report.

Comment entered 2021-03-30 09:52:58 by Kline, Bob (NIH/NCI) [C]

: which of these indexed attributes should the report use for narrowing by language?

/Media/MediaContent/Captions/MediaCaption/@language

/Media/MediaContent/ContentDescriptions/ContentDescription/@language

/Media/PhysicalMedia/ImageData/LabelName/@language

There's also a /Media/MediaContent/MediaLanguage element, but that's optional, and it's not indexed.

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

I think using these two below should be okay. The language attributes for each of the elements must match the media doc it is contained in (we have separate docs for English and Spanish with the Spanish ).  If they don't match, I believe that is a user error. Also, if this helps, we currently link the Spanish to the English using the TranslationOf element in the Spanish docs. 

 

/Media/MediaContent/Captions/MediaCaption/@language

/Media/MediaContent/ContentDescriptions/ContentDescription/@language
Comment entered 2021-03-30 11:49:19 by Kline, Bob (NIH/NCI) [C]

So I could use the presence/absence of the TranslationOf element to do the language filtering?

Comment entered 2021-03-30 13:39:46 by Osei-Poku, William (NIH/NCI) [C]

Yes. All the Spanish should have the TranslationOf element except a handful that are either new or were missed.

Comment entered 2021-03-31 13:12:59 by Kline, Bob (NIH/NCI) [C]

Enhancements implemented on CDR DEV.

Comment entered 2021-04-28 17:50:20 by Osei-Poku, William (NIH/NCI) [C]

I get the attached error message when I select  "adrenocortical carcinoma" for Diagnosis and "abnormal cells tissues" under Category with "Exclude blocked documents" and both languages selected. 

 

Comment entered 2021-04-29 07:08:59 by Kline, Bob (NIH/NCI) [C]

Fixed.

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

Verified on DEV. Thanks!

Comment entered 2021-06-02 18:04:39 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

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

Verified on PROD. Thanks!

Attachments
File Name Posted User
MediaListsReport Error.PNG 2021-04-28 17:50:14 Osei-Poku, William (NIH/NCI) [C]
MediaListsReportInterface.PNG 2021-04-28 17:50:14 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.001451