CDR Tickets

Issue Number 4655
Summary [DIS] Drug Information Comprehensive Review Date Report
Created 2019-08-23 11:13:05
Issue Type Improvement
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2020-06-11 17:43:58
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.248761
Description

We'd like to develop a report to view the comprehensive review date information that will soon be added to the drug information summaries (see linked issue dependency below). It should be modeled after the Summaries Comprehensive Review Date report, which is on the Board managers page, with a few minor changes to the interface.

 

On the report interface, we would like to have the following same options as are on the Summaries CRD Report: Display Review Dates, ID Display, Version Display, and Report Format. In addition to these options, we would like to be able to pull up the CRD information for all of the drug information summaries, only single-agent DIS, and only combination summaries. (See the Drug Info Summaries List report for an example of how we have done this on other reports.)

 

The report should be added to the Drug Information Reports page in the admin menus. Thanks.

Comment entered 2020-04-13 07:50:53 by Kline, Bob (NIH/NCI) [C]

Can you confirm that the Status and Comment columns which appear in the existing Summaries Comprehensive Review Date report will not be included in this report, since OCECDR-4654 is adding just a ComprehensiveReviewDate element to the DrugInformationSummary schema, not the entire ComprehensiveReview block?

Comment entered 2020-04-13 16:20:36 by Juthe, Robin (NIH/NCI) [E]

Glad you asked this question. I think it may make more sense to add the block of elements. (Actually, the status is just an attribute on the comprehensive review date element.) I'm checking with Christina on this.

Comment entered 2020-04-14 11:46:24 by Juthe, Robin (NIH/NCI) [E]

OK, good news - Christina wants only the Comprehensive Review Date added. So, no need for the attribute or the comment block. Therefore, what you've proposed for this report (eliminating the status and comment columns) is fine. Thank you!

Comment entered 2020-04-14 14:42:27 by Kline, Bob (NIH/NCI) [C]

So, modify what's been done for OCECDR-4654, stripping out the DateType attribute?

Comment entered 2020-04-14 15:01:02 by Juthe, Robin (NIH/NCI) [E]

I don't think a value is required on that attribute, so there's no harm in keeping it.

Comment entered 2020-04-16 12:29:55 by Kline, Bob (NIH/NCI) [C]

Actually, the attribute is required. Without it, we wouldn't be able to implement the Display Review Dates field, because we wouldn't know whether the review date were Actual.

Comment entered 2020-04-16 12:31:24 by Kline, Bob (NIH/NCI) [C]

Unless you want to change the meaning of that field to be Show only last review date (ignoring the date type).

Comment entered 2020-04-16 13:45:11 by Juthe, Robin (NIH/NCI) [E]

Let's change it to "show only last review date". Thanks!

Comment entered 2020-04-16 16:54:55 by Kline, Bob (NIH/NCI) [C]

Implemented on DEV.

Comment entered 2020-05-06 09:09:40 by Osei-Poku, William (NIH/NCI) [C]

It looks like the report is not on DIS menu. Could you please add it to the menu?

Comment entered 2020-05-06 09:44:26 by Kline, Bob (NIH/NCI) [C]

Installed on DEV menu.

Comment entered 2020-05-12 15:19:38 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV. Thanks!

Comment entered 2020-06-11 16:41:19 by Osei-Poku, William (NIH/NCI) [C]

It looks like the review dates are not being populated. I added a review date for 487564 and marked it as Actual but it doesn't display any date when I run the report by selecting either of the "Display Review Dates" options.

Comment entered 2020-06-11 17:43:58 by Kline, Bob (NIH/NCI) [C]

The query term definition had not been created. I took care of that and reindexed the drug docs (and added the definition to the list of manual tasks for the release). Please try again.

Comment entered 2020-06-11 17:45:50 by Osei-Poku, William (NIH/NCI) [C]

Yes, it is working now. Thanks!

Comment entered 2020-06-11 17:46:06 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Attachments
File Name Posted User
image-2020-04-16-12-30-20-796.png 2020-04-16 12:30:21 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.001508