{
  "name": "wpa/productivity_report/track_time_time_period.json",
  "database": "4d",
  "parameter": {
    "track_time_type": "OA",
    "show_sql": true,
    "start_date2": "",
    "end_date2": "",
    "load_group": [],
    "production_lot": [],
    "subqueryX": "SELECT record_id FROM work_phase_actual WHERE work__position_num_id IN (SELECT work__position_num_id FROM work_phase_actual WHERE date_ BETWEEN '{{start_date2}}' AND '{{end_date2}}' AND work_load_group_id IN ({{load_group}}))"
  },
  "query": [
    [
     "wpa_type_",
     "=",
     "track_time_type"
    ], "and",
    ["wpa_date_", ">=", "start_date2"], "and",
    ["wpa_date_", "<=", "end_date2"], "and",
    ["wpa_work_load_group_id", "in", "load_group"], "and",
    ["wpa_production_lot", "in", "production_lot"]
  ],
  "order": ["wo_row_number", "<", "wpa_date_", "<"],
  "field": [
    "wpa_work_load_group_id",
    "wpa_production_lot",
    "wpa_work_phase_est_id",
    "wpa_type_",
    "wpa_start_shift_number",
    "wpa_shift_number",
    "wpa_work_time__amount",
    "wpa_machine_hours",
    "wpa_target_time",
    "wpa_produced_amount",
    "wpa_failed_amount",
    "wpa_start_date",
    "wpa_start_time",
    "wpa_date_",
    "wpa_end_time",
    "wpa_track_time_status",
    "wpa_measured_track_time",
    "wpa_record_id",
    "wlg_name",
    "wlg_follow_track_time",
    "wo_drawing_number",
    "wo_work__position_num_id",
    "wo_row_number",
    "w_name",
    "wlg_use_automatic_receipt",
    "wpa_employee_id"
  ]
}
