SQL Reporting and Custom Services Workshop

Abstract

Mike Rogers (University of Tennessee).

This workshop covers a range of tips, hints, and suggestions for creating SQL reports using 'SELECT' statements. The first section will: 1) provide an overview of where Acquisitions, Serials, Circulation, and Cataloging data is stored in the Z-tables, 2) introduce a method for formulating ALEPH SQL queries, 3) explain "joins" and how to create them, 4) create and run an SQL script, and 5) explain nested queries, MINUS statements, and UNIONs. The second section will discuss the advantages of setting up SQL queries as "custom services" to be run from the ALEPH GUI modules, or even from a web page. We'll review the step-by-step process of doing this and examine the underlying programming pieces involved (shell script, XML/HTML, PHP, etc.). Version: All. Level: Familiarity with SQL, reporting, programming. The audience will learn more about Aleph SQL reporting and report distribution strategies to best fit their own institution needs. (Please note: if you didn't register for this workshop in advance, walk-ins are acceptable.)