CDR Tickets

Issue Number 3692
Summary Report to track published trials that need admin info.
Created 2013-12-17 12:35:26
Issue Type New Feature
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2014-01-29 17:43:47
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.116199
Description

We need a new report that is similar to the existing CTGov Protocol Processing Status Report, with the same columns/column names as the protocol processing status report. The only difference is that it will hold only trials with the new value ("Published - need admin info") being added to the CTGov Schema in OCECDR-3691. I think having it as a second tab in the same spreadsheet of the existing protocol processing status report should be fine. If it is easier or better to have it as its own report too that should be fine.

Comment entered 2013-12-18 08:18:56 by Osei-Poku, William (NIH/NCI) [C]

I wanted to add that even though our first choice would be to have this new report added to the existing report as a new tab, we should also be fine with an ad hoc query that retrieves all trials that have the new value. This might be the simplest approach since with the existing report, trials drop off as they are made publishable. Meanwhile, the new value will only be added when the scientific content has been processed and the trial is made publishable.

Comment entered 2013-12-18 16:36:24 by Kline, Bob (NIH/NCI) [C]

Implemented on DEV. You'll need to add the new status value to some protocols in order to test.

Comment entered 2013-12-18 17:25:33 by Osei-Poku, William (NIH/NCI) [C]

Awesome. I tested it on Dev and it seems to be working well. We will do additional tests tomorrow. Thank you!!!

Comment entered 2013-12-31 17:05:38 by Osei-Poku, William (NIH/NCI) [C]

We performed additional testing on DEV and everything looks good.

Comment entered 2014-01-28 13:43:56 by Kline, Bob (NIH/NCI) [C]

  • R12253 /trunk/Inetpub/wwwroot/cgi-bin/cdr/CTGovProtocolProcessingStatusReport.py

Comment entered 2014-01-29 11:35:17 by Osei-Poku, William (NIH/NCI) [C]

This report does not retrieve trials marked with "Published - need admin info". Here are some of the trials used for testing on QA: 750928 749502 749505 749541

Comment entered 2014-01-29 12:36:57 by Kline, Bob (NIH/NCI) [C]

The query_term_def table had not been populated with the /CTGovProtocol/ProtocolProcessingDetails/ProcessingStatus path. All tiers now have that row added to the table. The job to populate the query_term table with rows for that path on QA is running now. I'll let you know when the job has completed so you can re-test.

Comment entered 2014-01-29 16:10:46 by Kline, Bob (NIH/NCI) [C]

The job has finished. Please give the report another shot.

(BTW: we probably shouldn't close these issues until the changes have arrived safely on production.)

Comment entered 2014-01-29 17:25:34 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA.

Comment entered 2014-02-06 12:25:19 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD.

Elapsed: 0:00:00.001421