/// Список сотрудников
Query List() As %SQLQuery(CONTAINID =  1 )
{
	Select 
		ID,Name,
		NullIf((
			Select count(*)
			From wrk.Stage as e
			Where
				e.Member=a.ID
				and
				YEAR(dEnd)=YEAR(CURRENT_DATE)
		), 0 ) as Year,
		NullIf((
			Select count(*)
			From wrk.Stage as d
			Where
				d.Member=a.ID
				and
				YEAR(dEnd)=YEAR(CURRENT_DATE)
				and
				MONTH(dEnd)=MONTH(CURRENT_DATE)
		), 0 ) as Month,
		NullIf((
			Select count(*)
			From wrk.Stage as b
			Where
				b.Member=a.ID
				and
				dBeg is NULL
				and
				dEnd is NULL
		), 0 ) as Empt,
		NullIf((
			Select count(*)
			From wrk.Stage as c
			Where
				c.Member=a.ID
				and
				dBeg is not NULL
				and
				dEnd is NULL
		), 0 ) as NoCls,
		NullIf((
			Select count(*)
			From wrk.Stage as c
			Where
				c.Member=a.ID
				and
				c.Member->Prg= 1 
				and
				dEnd is not NULL
				and
				dSet is NULL
		), 0 ) as NoSet
	From wrk.Member as a
	Order by Name
}

<tablePane 
	id="tpMember" 
	tableName="wrk.Member" 
	valueColumn="ID"
	pageSize="20" 
	useSnapshot="true" 
	caption="Сотрудник" 
	queryClass="wrk.Member"
	queryName="List"
	onselectrow='zenPage.Select(zenThis.getValue("ID"))'
	ondblclick='zenPage.Edit(zenThis.getValue("ID"));' 
	showQuery="true"
>
	<column 
		header="Id" 
		colName="ID" 
		hidden="true"
	/>
	<column 
		header="ФИО" 
		colName="Name" 
	/>
	<column 
		header="За год" 
		colName="Year" 
		width="100px"
	/>
	<column 
		header="За месяц" 
		colName="Month" 
		width="100px"
	/>
	<column 
		header="Ожидают" 
		colName="Empt" 
		width="100px"
	/>
	<column 
		header="В работе" 
		colName="NoCls" 
		width="100px"
	/>
	<column 
		header="Не уст." 
		colName="NoSet" 
		width="100px"
	/>
</tablePane>

<column 
	header="За месяц" 
	colName="Month" 
	width="100px"
/>

and
MONTH(dEnd)=MONTH(CURRENT_DATE)

NullIf((
	Select count(*)
	From wrk.Stage as d
	Where
		d.Member=a.ID
		and
		YEAR(dEnd)=YEAR(CURRENT_DATE)
), 0 ) as Month,