search

CARLI / web-reports

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

Report "Bib records with particular subj heading strings dedup" results do not match Access #140

Open gibsonjc opened 6 years ago

gibsonjc commented 6 years ago

Number 8 from Issue #137 Description of a Library's Collection > General > Bib records with particular subj heading strings dedup

The problem is that it is not deduplicating the records. It is finding all of results but this version of the query is supposed to deduplicate the results output when the query text is found more than once in a single MARC record. Instead, it matches the results of the non-deduplicating version.

The non-deduplicating version is currently in Local Catalog Maintenance > Bibliographic Records > Subjects > Bibliographic records with particular subject heading strings (but eventually it needs to be moved to Description of a Library's Collection > General with this dedup version...that's my bad!)

dmcmpbll commented 6 years ago

Ah, it looks like the query listed in Web Reports for the "dedup" query is actually the SQL for the non-dedup version Jessica mentions: https://www.carli.illinois.edu/products-services/i-share/reports/secure/sql-desc#08-01 (Local Catalog Maintenance > Bibliographic Records > Subjects > Bibliographic records)

The dedup version should have a subquery and a main query: https://www.carli.illinois.edu/products-services/i-share/reports/secure/sql-desc#08-01a

Chris, do you want me to work to convert the dedup version's subquery and main query, or would you like to look into it?

csaundrs commented 6 years ago

Debbie,

Please give it a go and let me know if you need anything

Chris

From: dmcmpbll [notifications@github.com] Sent: Monday, December 11, 2017 11:56 AM To: CARLI/web-reports Cc: Saunders, Christopher; Assign Subject: Re: [CARLI/web-reports] Report "Bib records with particular subj heading strings dedup" results do not match Access (#140)

Ah, it looks like the query listed in Web Reports for the "dedup" query is actually the SQL for the non-dedup version Jessica mentions: https://www.carli.illinois.edu/products-services/i-share/reports/secure/sql-desc#08-01 (Local Catalog Maintenance > Bibliographic Records > Subjects > Bibliographic records)

The dedup version should have a subquery and a main query: https://www.carli.illinois.edu/products-services/i-share/reports/secure/sql-desc#08-01a

Chris, do you want me to work to convert the dedup version's subquery and main query, or would you like to look into it?

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHubhttps://github.com/CARLI/web-reports/issues/140#issuecomment-350804475, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ARrYZcnq6UJN7oH39CzDlCXE7VfW3sG7ks5s_WzVgaJpZM4QNNKj.