[Wactclc-alma] Alma Analytics query to find titles in ALL CAPS

[Thomas, Kirsti]

We recently figured out how to do a search for titles in all caps in Alma Analytics.  We use all caps titles in bib records for Reserves and uncataloged items (new orders, equipment, etc.) so being able to search for titles in all caps is really helpful for clean-up projects.  I thought it might be helpful for other folks.

Filter title column
Operator = is LIKE (pattern match)
Value field is blank
SQL Expression = UPPER(Title)
    Depending on the report subject area, you may have to use:
    UPPER(Bibliographic Details.Title)










Kirsti S. Thomas
Library Technical Services Manager
Seattle Colleges
kirsti.thomas at seattlecolleges.edu



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20210513/b3d8693b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Picture (Device Independent Bitmap) 1.jpg
Type: image/jpeg
Size: 19193 bytes
Desc: Picture (Device Independent Bitmap) 1.jpg
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20210513/b3d8693b/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Picture (Device Independent Bitmap) 2.jpg
Type: image/jpeg
Size: 19444 bytes
Desc: Picture (Device Independent Bitmap) 2.jpg
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20210513/b3d8693b/attachment-0001.jpg>