ELUNA Document Repository

SQL Reporting and Custom Services Workshop

Rogers, Mike (2007) SQL Reporting and Custom Services Workshop. In: ELUNA 2007, 5-8 June 2007, Spearfish, SD.

[img] PDF - Presentation
Restricted to Registered users only



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.)

Item Type:Conference or Workshop Item (Other)
Event Title:ELUNA 2007
Divisions:ELUNA Conference Proceedings
ID Code:362
Deposited On:30 Dec 2009 23:02
Last Modified:27 May 2016 21:04

Repository Staff Only: item control page