CDR Tickets

Issue Number 3109
Summary [TERMINOLOGY] Ad hoc queries
Created 2010-03-15 14:29:20
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2010-03-22 17:10:30
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107437
Description

BZISSUE::4785
BZDATETIME::2010-03-15 14:29:20
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku

Please write two terminology ad hoc queries for Drug terms without definition.
1. The first query should look for drug terms without definition that are on Active trials [Enrolling by Invitation, Approved Not-Yet Active & Active]

Display:
CDR ID | Preferred Name|

2. The second query should look for drug terms without definition that are on closed trials [Temporarily closed, Closed & Completed]

Display:
CDR ID | Preferred Name|

Please, add these reports to the ad hoc query menu.

Comment entered 2010-03-15 15:00:51 by Beckwith, Margaret (NIH/NCI) [E]

BZDATETIME::2010-03-15 15:00:51
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::1

These sound familiar. Are you sure we haven't done these before?

Comment entered 2010-03-15 15:55:28 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-03-15 15:55:28
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

(In reply to comment #1)
> These sound familiar. Are you sure we haven't done these before?

Yes. There is one for drugs without definition and that appears to list all statuses. But we want ones that separate the statuses.

Comment entered 2010-03-22 10:18:07 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-03-22 10:18:07
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3

Since you've turned over the Gen Prof. mailer issue for testing, I am increasing the priority of this issue to P4.

Comment entered 2010-03-22 11:14:06 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2010-03-22 11:14:06
BZCOMMENTOR::Bob Kline
BZCOMMENT::4

Installed on Bach:

Drug terms without definitions on active trials
Drug terms without definitions on inactive trials

Ready for user testing.

Comment entered 2010-03-22 17:10:30 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-03-22 17:10:30
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::5

(In reply to comment #4)
> Installed on Bach:
>
> Drug terms without definitions on active trials
> Drug terms without definitions on inactive trials
>
> Ready for user testing.

Tested. Looks Good. Issue closed. Thank you!

Elapsed: 0:00:00.001489