Serials Analysis
Overview
Opening the Analysis page presents the user with a view of existing queries.
- To build a new query, click on the NEW QUERY button in the upper right portion of the screen.
- To edit an existing query, or to examine the results in greater detail, click the EDIT button to the right of the query you wish to work with.
- Use the CLONE button to create a copy that can be edited while preserving the original.
The New Query screen is divided into two panels. The Query Builder is on the left and the results panel is on the right. As changes are made in the left panel, the right panel updates in real-time so the specific impact of each threshold can be seen.
Scroll down the right panel to view the query results.
Query Builder
Note that the left and right panels of the New Query screen scroll separately. If the left panel is hidden, click on the SHOW EDITOR tab on the left side of the screen.
At any time, you are invited to SAVE your query in the upper right portion of the screen. There is no limit on the number of queries that can be saved.
Please contact your GreenGlass liaison if you have query requirements that are not readily satisfied by the tools in GreenGlass. Your GreenGlass liaison can build more complex models and scenarios offline.
| Option | Description | ||||||
|---|---|---|---|---|---|---|---|
| SUBJECTS |
Choose the subject(s) to include:
Select LC or Dewey classes and subclasses. Projects processed after September 2018 will allow you to select one or more numeric ranges within a given LC or Dewey subclass (e.g., DA 757.9 - 826 Scottish History). For more information, watch the Tutorial: Subject and Call Numbers Searching (7:00). |
||||||
| CALL NUMBERS |
A Call Number search feature allows you to search for non-standard patterns and character strings in your call numbers (e.g. “oversize”, “folio”). This feature can be used to query for non-LC and non-Dewey classification marks. Options include:
|
||||||
| TITLE | Search by words in the title. To match on an exact phrase, enclose the phrase in quotation marks. | ||||||
| LOCATIONS | Select one or more location codes to include. For more information, watch the Tutorial: Collection and Location Codes in GreenGlass (3:00). | ||||||
| TYPES |
|
||||||
| LOCAL HOLDINGS DATES | Search by publication dates and data span covered in your local holding statement. | ||||||
| WORLDCAT™ PUBLICATION STATUS | Search by publication status (continuing, discontinued, other) | ||||||
| JOURNAL ARCHIVES | Search for titles held by selected journal archives. | ||||||
| WORLDCAT™ HOLDINGS |
|
||||||
| SPECIAL CATEGORY | If your library defined a special category, you have the option to include or exclude those titles from your query results. To see your Special Category Rules, click on the green question mark. | ||||||
| HATHITRUST |
Include or exclude titles based on their HathiTrust status. |
||||||
| COMBINE QUERIES |
At the bottom of the left panel, users have the option to combine the on-screen query with one or more queries that have been built and saved previously. Combined queries can be ORed or ANDed.
Combined queries can also be saved. For more information, watch the Tutorial: Combining Queries in GreenGlass (4:10). |
Exported Item Lists
To retrieve exported lists click on the details icon near your user name in the far upper right of the screen and navigate to MY DOWNLOADS. GreenGlass item lists that contain fewer than 300,000 rows (or items) are made available in Excel .xlsx format. Lists that exceed 300,000 rows will be delivered as .csv files.
These Excel spreadsheets are lightly formatted but it is recommended that you delete columns you don't need. You may also wish to add Filters to the header row (via the DATA menu) to isolate items with specific values, etc. Sometimes pivot tables can be helpful for certain types of analyses. If you are unfamiliar with Excel or if you have any questions about your downloaded files, contact your GreenGlass liaison.
Each item in exported lists is represented by a line in the spreadsheet, sorted by Title. The first row contains a label/header for each column.
Note: Some columns are not included in all exports, and even if the column is included, data may not be available for individual items. This could be the result of custom project specifications and/or inconsistencies in your library's data.
Online Item Lists
Throughout GreenGlass, lists of titles and holdings can be retrieved via any hyper-linked tally. Listings are sorted by title. Data elements immediately visible in the list include:
- The library's call number, which is derived from the library's item or bib record.
- The library's location code.
- Title and publisher, as available in the library's MARC record.
- A link to a title details page.
- Clicking on this brief item display, reveals additional data elements, supplied by GreenGlass.