CDR Tickets

As it turns out, the PP report identifies the CDR-ID from the SummaryURL attribute value in order to identify if the link is internal or external.  The link is internal if the CDR-ID of the selected document matches the current document.

Unfortunately, we have close to 200 (blocked) summary documents with the identical SummaryURL attribute value as another publishable summary.  This has the affect that - instead of creating an internal link - a link to an old, blocked document gets created.

We want to discuss if it's possible to fix this programatically.  The work around is to remove or otherwise modify the SummaryURL of the blocked document to ensure the URL of the to-be-published document is unique.

Here is a sample of the problem sorted by SummaryURL (Jira doesn't let me enter the entire table):

Volker will create a spreadsheet containing a complete list of the blocked summaries having URLs that match publishable summaries. He will add a column for the status of the document (blocked or not blocked).

William will find out if the summaries that have gone through the "Replace Doc" function then get blocked.

~oseipokuw, I've created the ad-hoc query Summaries without unique SummaryURL.  The query lists every summary for which its SummaryURL element is not unique. 

Please take a look and then we can adjust from here.  We probably want to exclude the test documents but for the first round I wanted to include everything.

Volker will add two columns to this adhoc query to display the document status and the date last modified (system).

I've added the audience, active_status, and last-version-saved date.

We decided to delete all the blocked summaries that had duplicate URL with active summaries identified by the query. I have finished deleting them from PROD.