CDR Tickets

Issue Number 3255
Summary Images not linked report
Created 2010-10-27 09:49:27
Issue Type Improvement
Submitted By Beckwith, Margaret (NIH/NCI) [E]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2010-10-28 12:25:39
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107583
Description

BZISSUE::4945
BZDATETIME::2010-10-27 09:49:27
BZCREATOR::Margaret Beckwith
BZASSIGNEE::Volker Englisch
BZQACONTACT::Robin Juthe

I need to talk to Kevin Broun about pulling some images from Visuals Online, and would like to get an adhoc report of CDR images that are not linked to any content on Cancer.gov. It would be helpful to see them broken down by those that are published to Cancer.gov but not linked, and those that aren't published to Cancer.gov. Please let me know if you need more information.

Comment entered 2010-10-27 10:59:56 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2010-10-27 10:59:56
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1

What is the information that you need for the images? Is it just the CDR-ID and title?

Comment entered 2010-10-27 13:05:55 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2010-10-27 13:05:55
BZCOMMENTOR::Volker Englisch
BZCOMMENT::2

I've created the adhoc query named
Images not linked to other Documents

This report lists the CDR-ID, title (from the document table), and a Yes/No column each indicating if the document is blocked, on Cancer.gov, and publishable for all media documents that are not linked to any other document.

Please be patient, the report takes about 60 seconds to finish.

This is ready to review on BACH's Query Interface.

Comment entered 2010-10-28 12:25:39 by Beckwith, Margaret (NIH/NCI) [E]

BZDATETIME::2010-10-28 12:25:39
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::3

This report looks okay. Closing issue.

Elapsed: 0:00:00.001563