- Posts: 9
- Thank you received: 4
queries
4 years 9 months ago #856
by constance
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
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
The following user(s) said Thank You: lwilliams
Please Log in to join the conversation.
- patrick20k
-
- Offline
- Admin
- Technical Writer at Keystone Systems
Less
More
- Posts: 458
- Thank you received: 72
4 years 9 months ago #858
by patrick20k
Replied by patrick20k on topic queries
Ooh, great topic!
I'll share a query for finding good candidates to move to duplication service:
Quick Search
(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'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
- Media | Delivery Method | Begins | P
- Media | Last Served Date | Is Between | 03/01/2019 | 03/12/2020
- Media | # Requests | Is Between | 50 | 99999
(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.)
Please Log in to join the conversation.
- SamLundberg
-
- Offline
- RANK3
Less
More
- Posts: 51
- Thank you received: 17
4 years 9 months ago #860
by SamLundberg
Replied by SamLundberg on topic queries
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
MedCode begins D;
Langcode begins E;
Series from aa to zz;
SerSeq equals 0;
Fiction begins Y;
Gradecode Does Not Equal J
Please Log in to join the conversation.
Time to create page: 0.047 seconds
