CDR Tickets

Issue Number 5177
Summary Global to replace Targeted Therapies Fact Sheet - Spanish Documents
Created 2022-12-01 09:54:27
Issue Type Task
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2022-12-12 15:57:22
Resolution Won't Fix
Path /home/bkline/backups/jira/ocecdr/issue.333612
Description

Please run a global change to replace the Targeted Therapy Fact Sheet for Spanish documents with the new URL below.  Run the global change separately for each document type instead of combining all of them in one global change. In all cases, replace or add the new SourceTitle value provided below. Please run the global change in test mode on DEV.  

 

Old URL: https://www.cancer.gov/espanol/recursos/hoja-informativa/terapias-dirigidas

 

New URL: https://www.cancer.gov/espanol/cancer/tratamiento/tipos/terapia-dirigida/hoja-informativa-terapias-dirigidas

New Source Title: Terapias dirigidas contra el cáncer - NCI

Comment entered 2022-12-01 10:21:18 by Osei-Poku, William (NIH/NCI) [C]

I searched the URL list report for summaries and could not find any document containing the old URL. Probably an ad hoc query to see if there are even any affected documents would be a good first step.

Comment entered 2022-12-12 09:05:20 by Kline, Bob (NIH/NCI) [C]
Comment entered 2022-12-12 10:49:08 by Osei-Poku, William (NIH/NCI) [C]

Thanks! Please proceed to run the global in test mode on QA.

Comment entered 2022-12-12 12:07:49 by Kline, Bob (NIH/NCI) [C]

OK, first of all, the description in the ticket says to run the job on DEV in test mode. That hasn't been done yet. My previous comment gave you the results of the ad-hoc report you requested in your first comment.

Second, you might want to take a closer look at that report output. Every single row has the new URL, not the old one. I assume that means someone has already gone in and made the switch by hand. It also might explain why you couldn't find any documents containing the old URL. My query was

SELECT doc_id AS "Doc ID", path AS Path, value AS URL
  FROM query_term
 WHERE value LIKE '%terapias-dirigida%'
Comment entered 2022-12-12 15:55:45 by Osei-Poku, William (NIH/NCI) [C]

I was planning to skip DEV altogether and start with QA instead. Thanks for the explanation. I thought the spreadsheet listed the documents with the old URL.

Comment entered 2022-12-12 15:57:22 by Osei-Poku, William (NIH/NCI) [C]

The global is not needed as the changes have already been completed. Thanks!

Attachments
File Name Posted User
targeted-therapies-links-spanish.xlsx 2022-12-12 09:01:34 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.001539