{
  "name": "wpa/productivity_report/work_time_sum.json",
  "database": "4d",
  "parameter": {
    "track_time_type": "OA",
    "production_lot": [],
    "query_name":""
  },
  "query": [
    [
      "wpa_production_lot",
      "in",
      "production_lot"
    ],
    [
      "wpa_type_",
      "<>",
      "track_time_type"
    ]
  ],
  "queryX": [
    [
      "if: query_name = only_fms",
      "wpa_employee_id",
      "=",
      "fms"
    ],
    [
      "if: query_name = no_fms",
      "wpa_employee_id",
      "<>",
      "fms"
    ]
  ],
  "field": [
    "wpa_production_lot",
    "wpa_work_phase_est_id",
    "wpa_work_time__amount",
    "wpa_date_",
    "wpa_record_id"
  ]
}
