eprintid: 362
rev_number: 10
eprint_status: archive
userid: 4
dir: disk0/00/00/03/62
datestamp: 2009-12-30 23:02:28
lastmod: 2016-05-27 21:04:20
status_changed: 2009-12-30 23:02:28
type: conference_item
metadata_visibility: show
item_issues_count: 0
creators_name: Rogers, Mike
title: SQL Reporting and Custom Services Workshop
ispublished: pub
subjects: aleph
divisions: eluna_conf
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.)
date: 2007-06-05
date_type: published
full_text_status: restricted
pres_type: other
event_title: ELUNA 2007
event_location: Spearfish, SD
event_dates: 5-8 June 2007
event_type: workshop
refereed: FALSE
citation: Rogers, Mike (2007) SQL Reporting and Custom Services Workshop. In: ELUNA 2007, 5-8 June 2007, Spearfish, SD.
document_url: https://beta-documents.el-una.org/id/eprint/362/1/ELUNA-2007-SQL-Reporting-Workshop.pdf