CDR Tickets

Issue Number 3301
Summary CiteMS Report Needed - list of topics assigned to board managers for review
Created 2011-01-21 15:13:37
Issue Type Improvement
Submitted By Boggess, Cynthia (NIH/NCI) [C]
Assigned To alan
Status Closed
Resolved 2011-02-03 09:08:03
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107629
Description

BZISSUE::4991
BZDATETIME::2011-01-21 15:13:37
BZCREATOR::Cynthia Boggess
BZASSIGNEE::Alan Meyer
BZQACONTACT::Cynthia Boggess

Request from Victoria Shields for a list of NCI staff (Victoria, Rick Manrow, & Judy Bader) who review citations for the Adult Rx board and which topics they are currently assigned to review. This info is in one of the CMS tables. I am attaching a report that Pete Chauvette generated from the DB years ago as an example of what she is needing.

Comment entered 2011-01-21 15:13:37 by Boggess, Cynthia (NIH/NCI) [C]

Attachment CIPSSummary_assign.xls has been added with description: Old Report, example of what info is needed in report

Comment entered 2011-01-25 18:05:39 by alan

BZDATETIME::2011-01-25 18:05:39
BZCOMMENTOR::Alan Meyer
BZCOMMENT::1

Here is the report.

I got it with this query (recorded here in case we need it again
or just wonder if I did it right):

SELECT DISTINCT r.cips_reviewer_desc, s.summary_name
FROM lu_cips_reviewer r
JOIN lu_summaries s
ON s.cips_reviewer_id = r.cips_reviewer_id
JOIN lu_editorial_board e
ON s.editorial_board_id = e.editorial_board_id
WHERE e.editorial_board_desc = 'Adult Treatment'
ORDER BY r.cips_reviewer_desc, s.summary_name

I took the output and loaded it into a spreadsheet in a format
matching the old report. I didn't include the editorial board
column from the old report since these are all Adult Treatment.

I'll also email it to Victoria since she's not a Bugzilla user.

Comment entered 2011-01-25 18:05:39 by alan

Attachment CIPS_Summary_Reviewers_2011-01-25.xls has been added with description: New report

Comment entered 2011-01-26 10:02:59 by Boggess, Cynthia (NIH/NCI) [C]

BZDATETIME::2011-01-26 10:02:59
BZCOMMENTOR::Cynthia Boggess
BZCOMMENT::2

This looks great Alan. Thanks!!

Comment entered 2011-01-26 11:08:43 by Boggess, Cynthia (NIH/NCI) [C]

BZDATETIME::2011-01-26 11:08:43
BZCOMMENTOR::Cynthia Boggess
BZCOMMENT::3

Victoria is happy with the report so I will close this bug.

Comment entered 2011-02-03 09:08:03 by Boggess, Cynthia (NIH/NCI) [C]

BZDATETIME::2011-02-03 09:08:03
BZCOMMENTOR::Cynthia Boggess
BZCOMMENT::4

Closing this bug.

Attachments
File Name Posted User
CIPS_Summary_Reviewers_2011-01-25.xls 2011-01-25 18:05:39
CIPSSummary_assign.xls 2011-01-21 15:13:37

Elapsed: 0:00:00.000629