{
	"name": "query/manager/person/employee/capacity_foreman.json",
	"table": [
		{
			"record_type": ["person"],
			"table": "person"
		}
	],
	"database": "4d",
	"parameter": {
		"show_sql": false,
		"subquery": "SELECT foreman_id from work_load_group"
	},
	"field": ["per.name", "per.person_id"],
	"order": [
		"per.name",
		">",
		"per.person_id",
		">"
	],
	"query": [
		["per.person_id", "in", "subquery"]
	]
}