{
	"name": "query/manager/resource/resource/resource/productivity_report.json",
	"info": "also form/manager/productivity_report/dropdown.json uses this query, needs extra fields",
	"table": [
		{
			"record_type": ["resource"],
			"table": "resource"
		}
	],
	"database": "4d",
	"parameter": {
		"active": ["active"]
	},
	"field": [
		"res.resource_id",
		"res.resource_name",
		"res.cell_resource_id",
		"res.json_data.calculate_target_time"
	],
	"order": ["res.resource_id", ">"],
	"query": [
		["res.resource_type", "=", "load_group"],
		"and",
		["res.resource_state", "in", "active"],
		"and",
		["res.json_data.calculate_target_time", ">", 0]
	]
}