{
  "masterRecordsTableName": "resource",
  "subRecordsTableName": "job",
  "groupedRecordsTableName": "booking",
  "loadUnassignedGroupedRecords": true,
  "showHistoricRecords": true,
  "fields": {
    "resource": [
      {
        "fieldName": "resource_guid",
        "fieldAlias": "resource_guid"
      },
      {
        "fieldName": "resource_userstatus",
        "fieldAlias": "resource_userstatus"
      },
      {
        "fieldName": "resource_description"
      }
    ],
    "job": [
      {
        "fieldName": "job_guid",
        "fieldAlias": "job_guid"
      },
      {
        "fieldName": "job_start",
        "fieldAlias": "job_start"
      },
      {
        "fieldName": "job_end",
        "fieldAlias": "job_end"
      },
      {
        "fieldName": "job_jobstatus_guid",
        "fieldAlias": "job_jobstatus_guid"
      },
      {
        "fieldName": "job_description"
      },
      {
        "fieldName": "job_client_guid"
      },
      {
        "fieldName": "job_jobstatus_guid.jobstatus_description"
      },
      {
        "fieldName": "job_client_guid.client_description"
      }
    ],
    "booking": [
      {
        "fieldName": "booking_guid",
        "fieldAlias": "booking_guid"
      },
      {
        "fieldName": "booking_start",
        "fieldAlias": "booking_start"
      },
      {
        "fieldName": "booking_end",
        "fieldAlias": "booking_end"
      },
      {
        "fieldName": "booking_bookingtype_guid",
        "fieldAlias": "booking_bookingtype_guid"
      },
      {
        "fieldName": "booking_loading",
        "fieldAlias": "booking_loading"
      },
      {
        "fieldName": "booking_nonwork",
        "fieldAlias": "booking_nonwork"
      },
      {
        "fieldName": "booking_fixedtime",
        "fieldAlias": "booking_fixedtime"
      },
      {
        "fieldName": "booking_job_guid",
        "fieldAlias": "booking_job_guid"
      },
      {
        "fieldName": "booking_resource_guid",
        "fieldAlias": "booking_resource_guid"
      },
      {
        "fieldName": "booking_time"
      },
      {
        "fieldName": "booking_bookingtype_guid.bookingtype_description"
      },
      {
        "fieldName": "booking_job_guid.job_description"
      },
      {
        "fieldName": "booking_resource_guid.resource_description"
      }
    ]
  },
  "filter": {
    "resource": {
      "filterGroupOperator": "And",
      "filterLines": [
        {
          "field": "resource_guid",
          "operator": "Contains",
          "value": [
            "2b2a2cc6-0b95-4511-97fa-c5fdb5347b19",
            "779deed5-a4f9-43d6-993d-82b3c6b44c6a"
          ]
        },
        {
          "field": "resource_has_skill",
          "operator": "Equals",
          "value": 1,
          "parameters": {
            "skillGuid": "cea6de18-9479-410b-29b7-08d7b050d353"
          }
        },
        {
          "field": "utilisation",
          "operator": "GreaterThanOrEqual",
          "value": 10,
          "parameters": {
            "startDate": "2020-04-02T23:00:00.000Z",
            "endDate": "2020-04-29T23:00:00.000Z"
          }
        },
        {
          "field": "resource_location_guid",
          "operator": "Contains",
          "value": [
            "2e4592bd-fbdb-4586-bd6f-7b8ee59588fc",
            "491b047d-1216-4206-9cfc-f99d53239d5b",
            "9c05588f-489a-41f8-bb2b-8472fcb2e5d3",
            "255eca09-9fef-40a5-8b1b-d5bb795abbc2",
            "e951dee7-779f-4190-aef2-aedb8892c623"
          ]
        },
        {
          "field": "resource_booking_count",
          "operator": "GreaterThan",
          "value": 1
        }
      ]
    },
    "job": {
      "filterGroupOperator": "And",
      "filterLines": [
        {
          "field": "job_guid",
          "operator": "Contains",
          "value": [
            "acd28619-b00f-4c4b-a2df-7a4e42d84d4f",
            "ce31e783-7e72-4afe-ab16-7021f5736790"
          ]
        }
      ]
    },
    "booking": {
      "filterGroupOperator": "And",
      "filterLines": [
        {
          "field": "booking_start",
          "operator": "GreaterThanOrEqual",
          "value": "2020-03-01T11:56:40.711Z"
        },
        {
          "field": "booking_end",
          "operator": "LessThanOrEqual",
          "value": "2020-06-07T10:57:06.762Z"
        },
        {
          "field": "booking_notes",
          "operator": "Like",
          "value": "a"
        }
      ]
    }
  },
  "order": {
    "resource": {
      "orderFields": [
        {
          "field": "resource_description",
          "order": "Ascending"
        }
      ]
    },
    "job": {
      "orderFields": [
        {
          "field": "job_client_guid.client_description",
          "order": "Ascending"
        }
      ]
    },
    "booking": {
      "orderFields": [
        {
          "field": "booking_start",
          "order": "Ascending"
        }
      ]
    }
  }
}