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