THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET

PROCEDURE 132: JGPUBDRAW

The query returns a list containing bibliographic citations for all published drawings of Frank Lloyd Wright commissions recorded in the database.

Note: The column labels shown within the query structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.

PROCEDURE NOTES

Procedure JGPUBDRAW calls on Tables Published Line Items and Published/Drawings with a filter applied on [COCOMMENTS] ("????") to select any record with a value in that row. The report format produced a block layout list showing bibliographic citation information, grouped by Frank Lloyd Wright client and project title with a subtotal count. The last generation of the report contained 9,935 entries.

The query structure is similar to PROCEDURE 47: PUBDRAWLIST and PROCEDURE 113: JGPUBDRAWSORTCLIENT in Database JDBGB10, and PROCEDURE 110: PUBDRAWLIST in Database JGDBFULL.

Database Search

Search based on this procedure can be executed through the version of the database available on the website.

  • Search Database

ORIGINAL DATAEASE PROCEDURE SCREENS

Query Structure

JGDB10 Procedure 132 query image

Report Format

JGDB10 Procedure 132 report form

Document: Dataease Procedure Definition Printout (PDF)