FacebookTwitterLinkedIn
Login / Register

Login / Register

IUG FORUM

Stay always connected!

Discussions tagged Create Lists

New Member

Automating searches to find course reserve materials?

At the beginning of each semester, we get a list of required texts from the bookstore. Currently, the circulation staff manually searches each title to see if we own it so it can be put on course reserve. I have been asked to automate a comparison of...
New Member

SQL to find permissions associated with item record change

Is there a way via SQL or any other way to see whose permissions are associated with changing an item record? For example, we would like to get a list of items where the status was changed in a particular time period. ajtaylor@scgov.net...
New Member

Late Fines vs. Billed/Damaged charges list

Does anyone out there in the collective wisdom know of a way to run a list in create lists that shows how fines were applied? Such as, a list of fines specific to late fees and a separate list of fines specific to damaged/billed materials? We want ...
Junior Member

Item Records - Create Date vs. Cat Date

Hi all, I am trying to get a list of items that have an incorrect I type – mainly, they are still marked as new and thus aren’t renewable. I noticed some older items not being renewable and they had an itype as “new hardbacks,”(I type 14 in our ca...
No Ranking

Teleforms Crashed. How do we find patrons?

How can I create list or use an SQL to retrieve patrons that should have been notified by teleforms between two dates?...
No Ranking

Finding Top Checkouts by Title

*NOTE: Posting on Sierra listserv as well* Our marketing person wants to publish a list of top circulated titles as a "year end" review. I am trying to find this via Create Lists (don't have any experience with SQL and we don't have ...
New Member

Create Lists find "\"

I'm trying to find if there are records in our system where the subfield delimiter has "\" instead of "|". When I put in "\" the system changes it to ":". I'm perflexed. Any suggestions? Thanks....
No Ranking

Need to find items linked to multiple bibs -- Millennium

Our cataloger is trying to find Item records that are linked to multiple Bibs. I thought that we could use the Linked Rec field in Create Lists, but when I have an Item level Create List that field is an option. When I look at Bib records (where Li...
Junior Member

Create Lists Q - Local Notes/590 - What am I doing wrong?

I am not having success trying to find any/all bibs that have the local notes field (MARC 590) in our system. I tried BIBLIOGRAPHIC MARC Tag 590 not equal to " " (blank space), but that's giving me records that do not have 590s as well a...
New Member

Item create list with reserve/course fields possible?

Have you ever created a review file (reserve, item or bib) for reserve/course fields? I swear I've done this before, but it didn't work today. iii is checking on whether it works, but I thought I'd ask the list also. I wanted to create an item r...
New Member

Sierra 2.2/2.3 Enhanced Query Builder screenshot

Hi everyone, Would someone be able to upload or point me to a screenshot of what the Enhanced Query Builder in Create Lists looks like in Sierra 2.2 or 2.3? We're on Sierra 2.0 but reading ahead in the documentation on the new features in Sierra ...
No Ranking

Diacritics in Create Lists

Hi, all, I have a question regarding searching for words with diacritics in Sierra Create Lists. Although I cannot find anything in the Create Lists section of the Sierra online help manual that specifically addresses diacritics, based on the &...
  • Page :
  • 1