CDR Tickets

I've attached specs for this new report. It's a complicated one! Let's discuss.

Please give it a try:

https://cdr.dev.cancer.gov/cgi-bin/cdr/ocecdr-3704.py

• R12426 /trunk/Inetpub/wwwroot/cgi-bin/cdr/ocecdr-3704.py

• R12425 /trunk/Inetpub/wwwroot/js/jquery.js

• R12425 /trunk/Inetpub/wwwroot/stylesheets/cdr.css

• R12424 /trunk/lib/Python/cdrcgi.py

When we use the Global Option by selecting "Permission Requested (English)", for example, no data is retrieved even though we've added the permission block to a few terms: 712808, 712360, 727321, 727106

Did you do this on DEV after the refresh from PROD (PROD doesn't have the query term definitions yet for this report)?

Actually the permissions data were copied from PROD during the recent refresh and we did the tests yesterday and this morning.

Then I will have to reindex all the data. (The expectation was that you'd be testing on DEV with data entered on that tier.)

All of the documents have been reindexed. Please test again. Just as a reminder: this is a very complicated report, so testing should be very thorough.

When I use the option enter the the CDR ID of either a glossary term or a summary and leave all other options blank, nothing is retrieved. Here are sample IDs I used:
CDR613538 - summary
CDR0000613538 - glossary
CDR0000428431 - glossary

Unless I am doing something wrong, I believe the report should show some data if Permission Granted is selected in the media docs permission information but it doesn't retrieve any data for all the IDs I used.

You're entering the document ID of the media documents, not the summary or glossary documents for which permission is granted. One clue is that you gave 613538 as the document ID of both a summary document and a glossary term name document.

You're right. Thanks. It works with the correct IDs.
I think everything is working as expected on DEV.

Still reviewing this, but please place each approved use on a separate line. Thanks.

A new line is now started for each approved use.

Does this need to be installed anywhere in the Admin menus (didn't see any requirements for that), or will you just bookmark the URL for this report?

Yes, please install it on the Media Reports page under Management Reports. Thanks.

Done.

Hi Bob,

The summary types should be the following:

ENGLISH
All English, Adult Treatment, Cancer Genetics, Complementary and Alternative Medicine, Pediatric Treatment, Screening and Prevention, Supportive and Palliative Care.

SPANISH
All Spanish, Adult Treatment, Pediatric Treatment, Screening and Prevention, Supportive and Palliative Care.

These values match up with the boards and are consistent with how we've designed other similar reports (see screenshot in the requirements doc).

Thanks.

I have rewritten that part of the request form and report to use boards instead of summary types. Please test carefully, as it's tricky code (largely because Spanish summaries don't know which boards are responsible for them, so you have to go find the English counterpart summary first, and then figure out which board is responsible for it). I made the labels on the form match what's being shown and selected, so the users (and other programmers using this as a model) don't fall into the same trap I did of thinking we should be looking at the SummaryType element.

Verified on DEV. I also verified copy/paste from Chrome into Word - that worked well. Thank you!

For consistency with other reports (PDQ Board roster & Summaries Type of Change), could you please swap the format options to list Web Page first and Excel Workbook second and make the Web Page the default format? Thank you.

Another note for testing on QA: The Excel report must be run in Chrome or Firefox.

Excel reports work in IE on PROD and QA. The fix for the Excel issues did not work on DEV for some reason and CBIIT continues to troubleshoot the problem.

The Global versions of this report (all permission requests for Eng/Spn, all denied requests) are not working. The column headings come up but no data appears. The specific versions are pulling in the data.

Query term definitions were missing. I have plugged in the missing definitions and the Media documents are being reindexed. Should work OK later this evening or tomorrow morning.

Thanks, Bob! I'll try again later.

It's working now. That was quick 🙂

Verified on QA.

The interface for the permissions report is messed up on prod. The first two boxes (option 1 & 2) fall off the page on the right. I've attached a screenshot. Thanks.

Someone has gone in and set IE on PROD to use a non-standard way of displaying standard HTML (you'll notice that every other browser does it right). Try clicking on the Page menu, select Compatibility View Settings, uncheck the "Display intranet sites in Compatibility View" box, and let me know if that doesn't help.

Like magic! I unchecked that setting and it looks fine now. Thanks!

Verified on prod.