queries

Queries:
I know that everyone runs queries for one reason or another so, I was wandering if any of you would share what queries you use and how you ran them? You can e-mail me if you have more than one favorite one.

Nancy help me with this query in finding books for a young reader that only wanted books that were so many minutes long.

Quick search
KLAS ID – begins - DB0
Subject – begins – whatever subject you want or leave blank
Advanced Search:
MarcTag - Tag - begins - 306
MarcTag - Subfield - begins - a
MarcTag - Data - Isbetween - 000000 - 001100

That last is the basically the time - HHMMSS - so hours, minutes, seconds.

Thanks,
Connie Sullivan

Ooh, great topic!

I'll share a query for finding good candidates to move to duplication service:
Quick Search

• Patron Type | Begins | PA
• Main Status | Equals | A
• Pat Medium | Equals | DB
• Medium Status | Equals | A

Advanced Search

• Media | Delivery Method | Begins | P
• Media | Last Served Date | Is Between | 03/01/2019 | 03/12/2020
• Media | # Requests | Is Between | 50 | 99999

This will find Active Patrons, who are Active in the DB Medium, currently on Physical Delivery (non-duplication), served in the past year (update the dates as needed), with 50 or more requests.

(FYI - I'm moving this topic from the Welcome Mat to KLAS Core, since queries can be used in both the Patron and Catalog modules.)

I've been trying to catch up on cataloging our series sequence information, so my best buddy has been:

MedCode begins D;
Langcode begins E;
Series from aa to zz;
SerSeq equals 0;
Fiction begins Y;
Gradecode Does Not Equal J