{
	"name": "query/manager/product/product_work/actual/productivity_report/old/work_time_sum.json",
	"table": [
		{
			"record_type": ["actual"],
			"table": "product_work"
		}
	],
	"database": "4d",
	"parameter": {
		"production_lot": [
				
			],
		"query_name": "",
		"track_time_type": "OA"
	},
	"field": [
		"prwo.production_lot",
		"prwo.work_phase_number",
		"prwo.work_hours",
		"prwo.json_data.end_date",
		"prwo.record_id"
	],
	"query": [
		["prwo.production_lot", "in", "production_lot"],
		["prwo.work_phase_type", "<>", "track_time_type"]
	],
	"queryX": [
		[
			"if: query_name = only_fms",
			"prwo.person_id",
			"=",
			"fms"
		],
		[
			"if: query_name = no_fms",
			"prwo.person_id",
			"<>",
			"fms"
		]
	]
}