CDR Tickets
| Issue Number | 5213 |
|---|---|
| Summary | Create new ad hoc query to identify summaries with duplicate browser titles |
| Created | 2023-03-03 13:15:00 |
| Issue Type | Improvement |
| Submitted By | Osei-Poku, William (NIH/NCI) [C] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2023-03-03 14:04:14 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.339911 |
As a CDR summary editor, I would want to be able to run an ad hoc query to see a list of summaries that have duplicate browser titles
Scenario: CDR is able to identify two or more summaries with the same text in the alt title element with attribute value of Browser
Given: I am a CDR summary editor
And I have permission to create or edit summary documents
When I create or edit summary documents
Then I want to be able to run the Summaries Duplicate Browser Titles ad hoc query to see a list of summaries with duplicate browser titles.
Installed on all four tiers as Duplicate Summary Browser Titles. On CDR DEV, where the global change has eliminated all duplicates, the results set is empty. On the other tiers, lots of duplicates are reported, most or all of which will be eliminated when the global change job is run in live mode on those tiers.
Could you please include the CDR ID? Male Cancer Treatment is reported on DEV but with no CDR ID.
That's not how a COUNT(*) query works. Aggregate queries (such as SELECT COUNT(*), ...) do what their name implies: they aggregate, so the individual rows which feed into the aggregation are not preserved. I created a separate query to find the documents with AltTitle of "Male Breast Cancer Treatment" (which is what I assume you meant to type):
Yes, this is good for finding the reported summaries. Thanks!
Verified. Thanks!
| File Name | Posted | User |
|---|---|---|
| image-2023-05-08-10-20-18-992.png | 2023-05-08 10:20:19 | Kline, Bob (NIH/NCI) [C] |
Elapsed: 0:00:00.001781