- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
Overview of using the LCCLASS_VW view (table) in Voyager's Prepackaged Access Reports.
This table parses LC class numbers, which greatly facilitates statistics by call number.
Consider the class number, ML410. Class=ML, classnumber=410, firstletter=M, longclass=MLbb410.
Those b’s are blanks. Longclass is padded with blanks so that numbers sort nicely. When a class number has a decimal point and digits following, these are not included in longclass.
If you are doing statistics by the first letter of the LC class code, you can easily add a description of the class to your results. Link firstletter in LCCLASS_VW to ClassLetter in LCClassBrief and show the Description field.
If you are doing statistics by the alphabetic part of the LC class code, you can easily add a description of the class to your results. Link firstletter in LCCLASS_VW to ClassLetters in LCClassDetailed and show the Description field.
The basic information provided here is also applicable to NLMCLASS_VW as the parsing is similar. DEWEYCLASS_VW is quite different, see: Overview of the DEWEYCLASS_VW view in Voyager Prepackaged Access Reports
Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes. Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.
- Article last edited: 19-Oct-2020