CDR Tickets

Issue Number 3297
Summary [Summaries] Problem using Comprehensive Review Date Report
Created 2011-01-14 09:38:17
Issue Type Improvement
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2011-01-14 13:29:36
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107625
Description

BZISSUE::4987
BZDATETIME::2011-01-14 09:38:17
BZCREATOR::Robin Juthe
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku

Robin B has entered comprehensive review dates for several of the CAM and Supportive Care summaries, nearly all with an attribute of "DateType=Actual". However, the CAM summaries are not displaying on the Summaries Comprehensive Review Date Report.

Here are a couple of examples of CAM summaries with comprehensive review dates:

441069 Aromatherapy
269596 Mistletoe

Could you please look into this? Thanks.

Comment entered 2011-01-14 09:48:17 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2011-01-14 09:48:17
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1

Is the problem only with the output for the CAM summaries or are there problems with the output for Supportive Care as well?

Comment entered 2011-01-14 09:50:18 by Juthe, Robin (NIH/NCI) [E]

BZDATETIME::2011-01-14 09:50:18
BZCOMMENTOR::Robin Juthe
BZCOMMENT::2

Just with CAM. The supportive care dates are displaying.

Comment entered 2011-01-14 11:11:45 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2011-01-14 11:11:45
BZCOMMENTOR::Volker Englisch
BZCOMMENT::3

If the report had never been used for the CAM summaries then Robin had found a bug which is now resolved. However, if the report used to work the CAM board name must have changed from 'Complementary and Alternative Medicine Board' to 'Cancer Complementary and Alternative Medicine Board'.

I've copied the changes to BACH since the bug was just a minor string change in a SQL query.

Please have a look if this is working correctly now.

Comment entered 2011-01-14 13:04:20 by Juthe, Robin (NIH/NCI) [E]

BZDATETIME::2011-01-14 13:04:20
BZCOMMENTOR::Robin Juthe
BZCOMMENT::4

The report is working fine now. Robin B has verified this. Thanks Volker.

Comment entered 2011-01-14 13:04:33 by Juthe, Robin (NIH/NCI) [E]

BZDATETIME::2011-01-14 13:04:33
BZCOMMENTOR::Robin Juthe
BZCOMMENT::5

Closing issue.

Comment entered 2011-01-14 13:29:36 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2011-01-14 13:29:36
BZCOMMENTOR::Volker Englisch
BZCOMMENT::6

A little bit of housekeeping is left.

The modified program has been stored in subversion:
SummaryCRD.py - R9994

Elapsed: 0:00:00.001625