CDR Tickets

Issue Number 4982
Summary Ad Hoc Query Request - Related Drug Summary Link URL report
Created 2021-06-04 12:50:28
Issue Type Task
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2021-06-08 18:57:28
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.291683
Description

Please Create an ad-hoc query for all glossary terms with Related Drug Summary Link URL. 

The display should be 

GTN ID, Term Type, Term Name, GTC ID, and Related Link

Comment entered 2021-06-08 18:18:30 by Englisch, Volker (NIH/NCI) [C]

What would you like the name for this query to be?

 

Please Create an ad-hoc query for all glossary terms with Related Drug Summary Link URL. 

There doesn't exist a URL for the related DIS links.  Would you like the DIS name or DIS CDR-ID to be displayed instead?

Comment entered 2021-06-08 18:33:59 by Osei-Poku, William (NIH/NCI) [C]

Please display both the DIS name and the DIS CDRID. Also, exclude blocked documents and please name it "Related Drug Summary Link Report"

Comment entered 2021-06-08 18:57:28 by Englisch, Volker (NIH/NCI) [C]

The query has been saved and is ready for review on DEV.

Comment entered 2021-06-09 14:54:22 by Osei-Poku, William (NIH/NCI) [C]

For the DIS Name column, please use the Title and not the Doc Title.

Comment entered 2021-06-09 21:09:28 by Englisch, Volker (NIH/NCI) [C]

OK, the query has been updated to display the DIS Title.

Comment entered 2021-06-17 09:37:58 by Osei-Poku, William (NIH/NCI) [C]

Looks good. Thank you,

Elapsed: 0:00:00.001829