Migration Workbench | Workspace: Sample data
RE
Report inventory › Arrest Detail with Incident - Agency H (Last 90 Days)
WI

Arrest Detail with Incident - Agency H (Last 90 Days)

Consolidate
SAP BusinessObjects Web Intelligence web intelligence document  ·  /Public Folders/Agency H/Arrests/Arrest Detail with Incident - Agency H (Last 90 Days)
Agency_H/Arrests/Arrest_Detail_with_Incident_-_Agency_H_(Last_90_Days).json
{
 "document": {
  "id": 53225,
  "cuid": "A15859ae6a0dfa5417caf9e",
  "name": "Arrest Detail with Incident - Agency H (Last 90 Days)",
  "folder": "Public Folders/Agency H/Arrests",
  "owner": "Administrator"
 },
 "dataProviders": [
  {
   "id": "DP0",
   "name": "Query 1",
   "dataSourceType": "unx",
   "dataSourceName": "Justice Reporting.unx",
   "queryplan": "<queryplan custom=\"false\" editable=\"true\"><statement index=\"1\">SELECT r.arrest_id, r.arrest_date, i.incident_id, i.occurred_date, i.beat FROM arrest r JOIN incident i ON i.incident_id = r.incident_id WHERE r.agency_id = 8 AND r.arrest_date BETWEEN '2026-07-02' AND '2026-09-30'</statement></queryplan>"
  }
 ],
 "reports": [
  {
   "id": 1,
   "name": "Report 1",
   "elements": [
    {
     "type": "VTable",
     "dataProvider": "DP0"
    }
   ],
   "sections": [
    {
     "name": "Agency"
    }
   ]
  }
 ],
 "alerters": [
  {
   "name": "Highlight late"
  }
 ],
 "variables": [],
 "parameters": []
}