    {
      "documents": [
          {
            "pos": 1,
            "docid": 3914,
            "mime_type": "application/pdf",
            "files": [
                {
                  "hash": "cf4eb2e0e9b3f7705a0d8d57825663ac",
                  "datasetid": "document",
                  "uri": "https://beta-documents.el-una.org/id/file/23553",
                  "hash_type": "MD5",
                  "objectid": 3914,
                  "fileid": 23553,
                  "mime_type": "application/pdf",
                  "filename": "Rogers Tips and Tricks for Alma Analytics.pdf",
                  "mtime": "2016-06-08 18:13:04",
                  "filesize": 2973971
                }
            ],
            "rev_number": 2,
            "placement": 1,
            "uri": "https://beta-documents.el-una.org/id/document/3914",
            "format": "application/pdf",
            "eprintid": 1365,
            "language": "en",
            "security": "validuser",
            "main": "Rogers Tips and Tricks for Alma Analytics.pdf"
          }
      ],
      "status_changed": "2016-06-08 18:15:06",
      "eprint_status": "archive",
      "divisions": [
        "eluna_conf"
      ],
      "subjects": [
        "Alma"
      ],
      "refereed": "FALSE",
      "creators": [
        {
          "name": {
            "lineage": null,
            "given": "Mike",
            "family": "Rogers",
            "honourific": null
          }
        }
      ],
      "date_type": "published",
      "type": "conference_item",
      "metadata_visibility": "show",
      "date": "2016-05-05",
      "abstract": "In this presentation I will share practical tips I\u2019ve learned over the past year of working with Alma Analytics.  We will look at a number of helpful functions such as SUBSTRING, COUNT, TRIM, REPLACE, LOCATE, LENGTH, IFNULL, CAST, CASE, and FILTER, and learn how these can be used to create simple yet powerful formulas for extracting data.  We\u2019ll review several formatting tips for tweaking the data output and also learn how to create a UNION query that combines two or more subject areas in one report.  Finally, I\u2019ll demo some reports that have proven handy at our site.  I\u2019ll strive to present material on a level that is useful to both beginners and advanced users.",
      "event_type": "conference",
      "dir": "disk0/00/00/13/65",
      "event_dates": "May 1-6, 2016",
      "event_title": "ELUNA 2016 Annual Meeting",
      "lastmod": "2016-06-08 18:15:06",
      "rev_number": 8,
      "title": "Tips & Tricks for Alma Analytics",
      "pres_type": "paper",
      "datestamp": "2016-06-08 18:15:06",
      "event_location": "Oklahoma City, OK USA",
      "uri": "https://beta-documents.el-una.org/id/eprint/1365",
      "ispublished": "pub",
      "userid": 24,
      "full_text_status": "restricted",
      "eprintid": 1365
    }