{
	"name": "query/manager/product/reclamation/productivity_report_time_period.json",
	"table": [
		{
			"record_type": [""],
			"table": "reclamation"
		}
	],
	"database": "4d",
	"parameter": {
		"end_date": "2015-08-31",
		"load_group": ["SAH", "BW1", "BW2"],
		"show_sql": false,
		"start_date": "2015-02-01"
	},
	"field": [
		"rcl.json_data.fault_made_resource_id",
		"rcl.reclamation_id",
		"rcl.reclamation_state",
		"rcl.finished_date",
		"rcl.production_lot",
		"rcl.json_data.purchase_product_id",
		"rcl.product_id",
		"pr.name",
		"rcl.repair_amount",
		"rcl.rejected_amount"
	],
	"query": [
		"date_period",
		"and",
		["rcl.calculation_type", "=", 1],
		"and",
		["rcl.json_data.fault_made_resource_id", "in", "load_group"]
	],
	"set": {
		"creation_date": [
				["rcl.creation_date", ">=", "start_date"],
				"and",
				["rcl.creation_date", "<=", "end_date"]
			],
		"date_period": ["creation_date", "or", "finished_date"],
		"finished_date": [
				["rcl.finished_date", ">=", "start_date"],
				"and",
				["rcl.finished_date", "<=", "end_date"]
			]
	}
}