{
  "name": "wpa/productivity_report/time_period_before.json",
  "database": "4d",
  "parameter": {
    "show_sql": false,
    "start_date2": "",
    "work_phase": [],
    "production_lot": []
  },
  "query": [
    ["wpa_date_", "<", "start_date2"], "and",
    ["wpa_work_phase_est_id", "in", "work_phase"], "and",
    ["wpa_production_lot", "in", "production_lot"]
  ],
  "aggregate": {
    "sum": [
      "wpa_work_time__amount"
    ]
  },
  "field": [
    "wpa_work_load_group_id",
    "wpa_production_lot",
    "wpa_work_phase_est_id",
    "wpa_work_time__amount"
  ]
}
