LSP Info Hub

LSP resources including top tasks, training, micro-learning, how-to's, and crowdsourced materials and code snippets. 

Searching for active item holds using a Sierra SQL query

Last updated:
Jun 24, 2025
Topic(s):
Database maintenance, Legacy
Summary:

Find items with holds still active using a Sierra SQL query.

Saving Global Updates

Last updated:
Apr 28, 2023
Topic(s):
Database maintenance, Global Update
Summary:

Create and save Global Update commands for reuse

Rolling Over Ledgers

Last updated:
Jun 16, 2025
Topic(s):
Top Task, How to, Alma, Acquisitions
Summary:

These links relate to the rolling over Ledgers for the fiscal year. 

Return Materials at the Circulation Desk

Last updated:
May 12, 2025
Topic(s):
Alma, Fulfillment, Circulation, How to
Summary:

When your institution’s physical items are returned, use this workflow to check in materials.

Reposition Browse Search Arrows

Last updated:
Aug 15, 2025
Topic(s):
Crowdsourced, Code snippet, Primo VE
Summary:

Code snippets to move the Primo VE Browse Search navigation arrows to display higher up on the page (so they aren't blocked by a chat widget.)

 

Removing OCLC prefixes in 001 field using a Sierra SQL query

Last updated:
Jun 24, 2025
Topic(s):
Database maintenance, Legacy
Summary:

 Ensure that OCLC prefixes are not in the 001 field using a SQL query.

Removing OCLC prefixes in 001 field

Last updated:
Sep 15, 2022
Topic(s):
Database maintenance
Summary:

Ensure that OCLC prefixes are not in the 001 field.

Removing Historical Suppression Codes

Last updated:
Sep 15, 2022
Topic(s):
Database maintenance, Legacy
Summary:

Search your local database for historical suppression codes no longer in use and update them to the current ones.

Removing Historical Rave Links using a Sierra SQL query

Last updated:
Jun 24, 2025
Topic(s):
Database maintenance, Legacy
Summary:

Search for historical rave links no longer in use using a Sierra SQL query and delete them from any records.

Removing Historical Rave Links

Last updated:
Sep 15, 2022
Topic(s):
Database maintenance, Legacy
Summary:

Search for historical rave links no longer in use and delete them from any records.

Pages