CDR Tickets

Issue Number 5031
Summary [DIS] Drug Reference - Spreadsheet of existing DrugReference elements with NCI Type
Created 2021-09-22 13:44:40
Issue Type Improvement
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2022-01-21 16:57:56
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.299300
Description

We'd like to generate a spreadsheet in order to identify which DrugReference blocks should be flagged as temporary for subsequent removal. We think there may be some patterns in the URLs that we could use for this purpose and may be more reliable than using the fragment from an associated miscellaneous document.

The spreadsheet should include a list of all DrugReference links in the DIS with the DrugReferenceType 'NCI'.

These are the columns we would like to have displayed:

  • CDR ID

  • Drug Name ('Title' element in the document)

  • DrugReferenceLink text

  • DrugReferenceLink URL

  • PostedDate

  • DrugReferenceType (this should always say NCI given the inclusion criteria, but it will be good to have spelled out in case we review this sheet again in the future)

  • DrugReferenceDescription (this is where we have been adding the fragment ID from the misc document)

Please sort the spreadsheet by Drug Name.

Comment entered 2021-09-22 15:02:59 by Kline, Bob (NIH/NCI) [C]

For the DrugReferenceDescription column, you want the text content for the element, not the cdr:ref attribute, right?

Comment entered 2021-09-22 16:04:12 by Kline, Bob (NIH/NCI) [C]

What should the report do with Insertion and Deletion markup? For example,

 {code:xml}
<DrugReferencePostedDate>
<Deletion UserName="barnsteadm" Time="Wednesday, September 22, 2021 10:45:08 AM" RevisionLevel="approved">2021-08-26</Deletion>
<Insertion UserName="barnsteadm" Time="Wednesday, September 22, 2021 10:45:22 AM" RevisionLevel="approved">2021-09-15</Insertion>
</DrugReferencePostedDate>

Comment entered 2021-09-22 16:46:04 by Kline, Bob (NIH/NCI) [C]

I went ahead and generated the report assuming the answer to my first question (should I use the text content for the description element instead of the cdr:ref attribute?) was "Yes" and applying the default revision level ("published") to resolve the Insertion/Deletion markup.

Comment entered 2021-10-05 20:29:46 by Juthe, Robin (NIH/NCI) [E]

The report looks great and will be really helpful in determining which drug reference blocks we want to have the TemporaryLink element added to in the global. Christina and Mary will review the spreadsheet and we'll circle back when we're ready to proceed. Thanks!

Comment entered 2021-12-16 14:09:59 by Kline, Bob (NIH/NCI) [C]

We need to generate a fresh spreadsheet. Exclude links with "about-cancer" in the URL.

Comment entered 2022-01-20 11:16:04 by Juthe, Robin (NIH/NCI) [E]

, could you please generate this updated spreadsheet?

Comment entered 2022-01-20 12:23:14 by Kline, Bob (NIH/NCI) [C]

Here you go. ocecdr_5031-1.xlsx

Comment entered 2022-06-13 12:37:52 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV. Thanks!

Attachments
File Name Posted User
ocecdr_5031.xlsx 2021-09-22 16:42:39 Kline, Bob (NIH/NCI) [C]
ocecdr_5031-1.xlsx 2022-01-20 12:21:45 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.002013