{
	"name": "query/manager/product/product_work/actual/productivity_report/quality.json",
	"table": [
		{
			"record_type": ["actual"],
			"table": "product_work"
		}
	],
	"database": "4d",
	"parameter": {
		"end_date": "",
		"load_group": "",
		"start_date": ""
	},
	"field": [
		"prwo.resource_id",
		"prwo.produced_amount",
		"prwo.failed_amount",
		"prwo.json_data.end_date",
		"prwo.json_data.end_time",
		"prwo.json_data.work_shift"
	],
	"query": [
		["prwo.json_data.end_date", ">=", "start_date"],
		"and",
		["prwo.json_data.end_date", "<=", "end_date"],
		"and",
		["prwo.resource_id", "in", "load_group"],
		"and",
		"amount_not_zero"
	],
	"set": {
		"amount_not_zero": [
				["prwo.produced_amount", "<>", 0],
				"or",
				["prwo.produced_amount", "<>", 0]
			]
	}
}