{
	"name": "query/manager/product/reclamation/productivity_report/time_period.json",
	"table": [
		{
			"record_type": [
				""
			],
			"table": "reclamation"
		}
	],
	"database": "4d",
	"parameter": {
		"end_date": "",
		"load_group": [],
		"start_date": ""
	},
	"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",
		"rcl.record_id"
	],
	"query": [
		"date_period"
	],
	"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"
			]
		]
	}
}