Advertisement
Guest User

Untitled

a guest
Apr 8th, 2020
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 4.19 KB | None | 0 0
  1. {
  2.   "masterRecordsTableName": "job",
  3.   "subRecordsTableName": "resource",
  4.   "groupedRecordsTableName": "booking",
  5.   "loadUnassignedGroupedRecords": true,
  6.   "showHistoricRecords": true,
  7.   "fields": {
  8.     "job": [
  9.       {
  10.         "fieldName": "job_guid",
  11.         "fieldAlias": "job_guid"
  12.       },
  13.       {
  14.         "fieldName": "job_start",
  15.         "fieldAlias": "job_start"
  16.       },
  17.       {
  18.         "fieldName": "job_end",
  19.         "fieldAlias": "job_end"
  20.       },
  21.       {
  22.         "fieldName": "job_jobstatus_guid",
  23.         "fieldAlias": "job_jobstatus_guid"
  24.       },
  25.       {
  26.         "fieldName": "job_description"
  27.       },
  28.       {
  29.         "fieldName": "job_client_guid"
  30.       },
  31.       {
  32.         "fieldName": "job_jobstatus_guid.jobstatus_description"
  33.       },
  34.       {
  35.         "fieldName": "job_client_guid.client_description"
  36.       }
  37.     ],
  38.     "resource": [
  39.       {
  40.         "fieldName": "resource_guid",
  41.         "fieldAlias": "resource_guid"
  42.       },
  43.       {
  44.         "fieldName": "resource_userstatus",
  45.         "fieldAlias": "resource_userstatus"
  46.       },
  47.       {
  48.         "fieldName": "resource_description"
  49.       }
  50.     ],
  51.     "booking": [
  52.       {
  53.         "fieldName": "booking_guid",
  54.         "fieldAlias": "booking_guid"
  55.       },
  56.       {
  57.         "fieldName": "booking_start",
  58.         "fieldAlias": "booking_start"
  59.       },
  60.       {
  61.         "fieldName": "booking_end",
  62.         "fieldAlias": "booking_end"
  63.       },
  64.       {
  65.         "fieldName": "booking_bookingtype_guid",
  66.         "fieldAlias": "booking_bookingtype_guid"
  67.       },
  68.       {
  69.         "fieldName": "booking_loading",
  70.         "fieldAlias": "booking_loading"
  71.       },
  72.       {
  73.         "fieldName": "booking_nonwork",
  74.         "fieldAlias": "booking_nonwork"
  75.       },
  76.       {
  77.         "fieldName": "booking_fixedtime",
  78.         "fieldAlias": "booking_fixedtime"
  79.       },
  80.       {
  81.         "fieldName": "booking_resource_guid",
  82.         "fieldAlias": "booking_resource_guid"
  83.       },
  84.       {
  85.         "fieldName": "booking_job_guid",
  86.         "fieldAlias": "booking_job_guid"
  87.       },
  88.       {
  89.         "fieldName": "booking_time"
  90.       },
  91.       {
  92.         "fieldName": "booking_bookingtype_guid.bookingtype_description"
  93.       },
  94.       {
  95.         "fieldName": "booking_resource_guid.resource_description"
  96.       },
  97.       {
  98.         "fieldName": "booking_job_guid.job_description"
  99.       }
  100.     ]
  101.   },
  102.   "filter": {
  103.     "job": {
  104.       "filterGroupOperator": "And",
  105.       "filterLines": [
  106.         {
  107.           "field": "job_guid",
  108.           "operator": "Contains",
  109.           "value": [
  110.             "acd28619-b00f-4c4b-a2df-7a4e42d84d4f",
  111.             "ef22caec-8855-4e45-ad75-3c49928d6fc8",
  112.             "ce31e783-7e72-4afe-ab16-7021f5736790",
  113.             "7f63747c-d5e0-4b53-b826-4cd83e2adb4c",
  114.             "c8893bc8-8db4-4664-8102-d00dd096c294"
  115.           ]
  116.         },
  117.         {
  118.           "field": "job_code",
  119.           "operator": "Like",
  120.           "value": "a"
  121.         }
  122.       ]
  123.     },
  124.     "resource": {
  125.       "filterGroupOperator": "And",
  126.       "filterLines": [
  127.         {
  128.           "field": "resource_guid",
  129.           "operator": "Contains",
  130.           "value": [
  131.             "2b2a2cc6-0b95-4511-97fa-c5fdb5347b19",
  132.             "779deed5-a4f9-43d6-993d-82b3c6b44c6a"
  133.           ]
  134.         }
  135.       ]
  136.     },
  137.     "booking": {
  138.       "filterGroupOperator": "And",
  139.       "filterLines": [
  140.         {
  141.           "field": "booking_start",
  142.           "operator": "GreaterThanOrEqual",
  143.           "value": "2020-02-04T09:29:36.483Z"
  144.         },
  145.         {
  146.           "field": "booking_end",
  147.           "operator": "LessThanOrEqual",
  148.           "value": "2022-04-16T08:26:20.828Z"
  149.         }
  150.       ]
  151.     }
  152.   },
  153.   "order": {
  154.     "job": {
  155.       "orderFields": [
  156.         {
  157.           "field": "job_client_guid.client_description",
  158.           "order": "Ascending"
  159.         }
  160.       ]
  161.     },
  162.     "resource": {
  163.       "orderFields": [
  164.         {
  165.           "field": "resource_description",
  166.           "order": "Ascending"
  167.         }
  168.       ]
  169.     },
  170.     "booking": {
  171.       "orderFields": [
  172.         {
  173.           "field": "booking_start",
  174.           "order": "Ascending"
  175.         }
  176.       ]
  177.     }
  178.   },
  179.   "masterRecordIds": []
  180. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement