Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "masterRecordsTableName": "job",
- "subRecordsTableName": "resource",
- "groupedRecordsTableName": "booking",
- "loadUnassignedGroupedRecords": true,
- "showHistoricRecords": true,
- "fields": {
- "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"
- }
- ],
- "resource": [
- {
- "fieldName": "resource_guid",
- "fieldAlias": "resource_guid"
- },
- {
- "fieldName": "resource_userstatus",
- "fieldAlias": "resource_userstatus"
- },
- {
- "fieldName": "resource_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_resource_guid",
- "fieldAlias": "booking_resource_guid"
- },
- {
- "fieldName": "booking_job_guid",
- "fieldAlias": "booking_job_guid"
- },
- {
- "fieldName": "booking_time"
- },
- {
- "fieldName": "booking_bookingtype_guid.bookingtype_description"
- },
- {
- "fieldName": "booking_resource_guid.resource_description"
- },
- {
- "fieldName": "booking_job_guid.job_description"
- }
- ]
- },
- "filter": {
- "job": {
- "filterGroupOperator": "And",
- "filterLines": [
- {
- "field": "job_guid",
- "operator": "Contains",
- "value": [
- "acd28619-b00f-4c4b-a2df-7a4e42d84d4f",
- "ef22caec-8855-4e45-ad75-3c49928d6fc8",
- "ce31e783-7e72-4afe-ab16-7021f5736790",
- "7f63747c-d5e0-4b53-b826-4cd83e2adb4c",
- "c8893bc8-8db4-4664-8102-d00dd096c294"
- ]
- },
- {
- "field": "job_code",
- "operator": "Like",
- "value": "a"
- }
- ]
- },
- "resource": {
- "filterGroupOperator": "And",
- "filterLines": [
- {
- "field": "resource_guid",
- "operator": "Contains",
- "value": [
- "2b2a2cc6-0b95-4511-97fa-c5fdb5347b19",
- "779deed5-a4f9-43d6-993d-82b3c6b44c6a"
- ]
- }
- ]
- },
- "booking": {
- "filterGroupOperator": "And",
- "filterLines": [
- {
- "field": "booking_start",
- "operator": "GreaterThanOrEqual",
- "value": "2020-02-04T09:29:36.483Z"
- },
- {
- "field": "booking_end",
- "operator": "LessThanOrEqual",
- "value": "2022-04-16T08:26:20.828Z"
- }
- ]
- }
- },
- "order": {
- "job": {
- "orderFields": [
- {
- "field": "job_client_guid.client_description",
- "order": "Ascending"
- }
- ]
- },
- "resource": {
- "orderFields": [
- {
- "field": "resource_description",
- "order": "Ascending"
- }
- ]
- },
- "booking": {
- "orderFields": [
- {
- "field": "booking_start",
- "order": "Ascending"
- }
- ]
- }
- },
- "masterRecordIds": []
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement