search

CARLI / web-reports

Web Reports Web Based Reporting Tool
2 stars 0 forks source link

5 Reports Ready for Testing #150

Open csaundrs opened 5 years ago

csaundrs commented 5 years ago

There are 4 reports that are ready for testing:

-> Local Cat Maintenance -> Bib Records -> Fixed Fields -> Bibs with format beginning ‘g’ but no video GMD -> Local Cat Maintenance -> Bib Records -> Fixed Fields ->Bibs with format beginning ‘i’ or ‘j’ but no sound recording GMD. -> Local Cat Maintenance -> Bib Records -> Fixed Fields ->Bibs with sound recording GMD but record type is not ‘i’ or ‘j’ -> Local Cat Maintenance -> Bib Records -> Fixed Fields ->Bibs with video GMD but record type is not ‘g’

csaundrs commented 5 years ago

Another one is ready:

Local Cat Maintenance -> Bib Records -> General -> MFHDs that are suppressed from OPAC with Items attached

dmcmpbll commented 5 years ago

Local Cat Maintenance -> Bib Records -> Fixed Fields -> Bibs with format beginning ‘g’ but no video GMD

is named "Bibs Beginning with G but no video GMD" in devel

Just FYI for me because it's Friday.

dmcmpbll commented 5 years ago

Jen and I worked together on testing these 5 queries this afternoon, and we have a few edits to be made to the code:

-- We found that the capitalization of the GMD was variable in some libraries, leading to inclusion or exclusion of results depending on how the GMD was capitalized. Can you add in more criteria to account for variable capitalizations? Perhaps either using a lcase/ucase function for the criteria field, or, by adding in more criteria rows with alternative capitalizations? -- We'll want to do more testing of these once the capitalization is adjusted. For "Bibs with format beginning ‘g’ but no video GMD" and for "Bibs with sound recording GMD but record type is not ‘i’ or ‘j’" there may be another issue that may need adjusted, but we'd like to start with the capitalization.

-- For this query, I removed the two LOCATION_ID criteria (<>47 and <>51). The Shared SQL on the CARLI website will also be updated to remove this criteria; it was too specific to the authoring library. We'll add in more description about this report soon, but it is almost ready for prod.

csaundrs commented 5 years ago

Debbie,

I made the changes to these 2 reports so that the title criteria is converted to lower case for comparison:

Bibs with format beginning ‘g’ but no video GMD Bibs with video GMD but record type is not ‘g’

Check to see if those 2 (on Devel) give you the results you would expect now. If they do, I will go ahead and make similar changes to the other 3 reports.

dmcmpbll commented 5 years ago

Shared SQL for 5th query to update: https://www.carli.illinois.edu/products-services/i-share/reports/secure/sql-local-cat2#0927b

dmcmpbll commented 5 years ago

MFHDs that are suppressed from OPAC with Items attached is ready for Prod.

For the other four GMD queries, Jen will check with Ted for more information on what we should be expecting in the results.

gibsonjc commented 5 years ago

"MFHDs that are suppressed from OPAC with Items attached" has been moved to Prod.

jenhm commented 5 years ago

I talked to Ted about the "GMD" related reports. These reports are dated and those in Access may not have been updated for all scenarios at this point. After talking to him about it we decided that it probably isn't worth adding these to web reports because of this, as well as the fact that Alma uses primarily the 007 for material type faceting.