{
	"name": "query/manager/product/reclamation/productivity_report_time_period_test.json",
	"info": "query/manager/product/reclamation/productivity_report_time_period_test.json",
	"table": [
		{
			"record_type": [""],
			"table": "reclamation"
		}
	],
	"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"],
	"databaseZ": "4d",
	"query": ["test", "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": [
				["rcl.creation_date", ">=", "start_date"],
				"and",
				["rcl.creation_date", "<=", "end_date"],
				"or",
				"finished_date"
			],
		"finished_date": [
				["rcl.finished_date", ">=", "start_date"],
				"and",
				["rcl.finished_date", "<=", "end_date"]
			],
		"test": [
				["rcl.creation_date", ">=", "start_date"]
			]
	}
}