{
      "eprintid": 404,
      "lastmod": "2016-05-27 21:04:29",
      "abstract": "Mike Rogers (University of Tennessee); Nikki Crowster (CALICO, South Africa), Moderator.\r\n\r\nAre you interested in ALEPH reports? This \"non-technical\" introduction will demonstrate the usefulness of SQL reporting. We'll cover many basics, review steps for turning an SQL script into a GUI \"custom service,\" and examine reports our site has found helpful. Documentation and a take home exercise are available to participants.",
      "title": "Beginner's SQL Reporting Workshop",
      "item_issues_count": 0,
      "date": "2006-06-05",
      "subjects": [
        "aleph"
      ],
      "event_dates": "4-7 June 2006",
      "event_title": "ELUNA 2006",
      "documents": [
          {
            "eprintid": 404,
            "pos": 1,
            "formatdesc": "Workshop Document",
            "security": "validuser",
            "uri": "https://beta-documents.el-una.org/id/document/528",
            "main": "beginnersSQL_rogers.doc",
            "mime_type": "application/msword",
            "files": [
                {
                  "mime_type": "application/msword",
                  "fileid": 7735,
                  "filesize": 1055232,
                  "filename": "beginnersSQL_rogers.doc",
                  "datasetid": "document",
                  "uri": "https://beta-documents.el-una.org/id/file/7735",
                  "mtime": "2016-05-27 21:04:29",
                  "objectid": 528
                }
            ],
            "content": "published",
            "rev_number": 4,
            "format": "application/msword",
            "docid": 528,
            "language": "en"
          },
          {
            "eprintid": 404,
            "pos": 2,
            "formatdesc": "Take Home Exercise Document",
            "security": "validuser",
            "uri": "https://beta-documents.el-una.org/id/document/529",
            "main": "beginnersSQLtakehome_rogers.doc",
            "mime_type": "application/msword",
            "files": [
                {
                  "mime_type": "application/msword",
                  "fileid": 7736,
                  "filesize": 303104,
                  "filename": "beginnersSQLtakehome_rogers.doc",
                  "datasetid": "document",
                  "uri": "https://beta-documents.el-una.org/id/file/7736",
                  "mtime": "2016-05-27 21:04:29",
                  "objectid": 529
                }
            ],
            "content": "supplemental",
            "rev_number": 4,
            "format": "application/msword",
            "docid": 529,
            "language": "en"
          }
      ],
      "event_location": "Knoxville, TN",
      "full_text_status": "restricted",
      "type": "conference_item",
      "event_type": "workshop",
      "userid": 4,
      "pres_type": "other",
      "refereed": "FALSE",
      "eprint_status": "archive",
      "metadata_visibility": "show",
      "datestamp": "2009-12-31 13:48:25",
      "uri": "https://beta-documents.el-una.org/id/eprint/404",
      "dir": "disk0/00/00/04/04",
      "ispublished": "pub",
      "status_changed": "2009-12-31 13:48:25",
      "rev_number": 10,
      "divisions": [
        "eluna_conf"
      ],
      "creators": [
        {
          "name": {
            "given": "Mike",
            "honourific": null,
            "lineage": null,
            "family": "Rogers"
          }
        },
        {
          "name": {
            "given": "Nikki",
            "honourific": null,
            "lineage": null,
            "family": "Crowster"
          }
        }
      ],
      "date_type": "published"
    }