Running SQL in the criteria area of Alma Analytics is a powerful and often underused tool. Any user can manually enter SQL to match a field in the main reports area to any other instance of the field in Analytics. This lets us accomplish tasks and comparisons that are not currently included in the Ex Libris documentation. This session will cover running queries in different areas, running queries in multiple different areas, and avoiding the dreaded NOT IN subqueries that time out reports.
Running SQL in the criteria area of Alma Analytics is a powerful and often underused tool. Any user can manually enter SQL to match a field in the main reports area to any other instance of the field in Analytics. This lets us accomplish tasks and comparisons that are not currently included in the Ex Libris documentation. This session will cover running queries in different areas, running queries in multiple different areas, and avoiding the dreaded NOT IN subqueries that time out reports.
Santa Anita B,C Ex Libris Knowledge Days and ELUNA Conference 2026 eluna-conf-planning@exlibrisusers.orgTechnical Issues?
If you're experiencing playback problems, try adjusting the quality or refreshing the page.
Questions for Speakers?
Use the Q&A tab to submit questions that may be addressed in follow-up sessions.