<tablePane 
	id="tpTask2" 
	tableName="wrk.Task as a INNER JOIN wrk.Job as b ON (a.ID=b.Task)LEFT OUTER JOIN wrk.Stage as c ON (b.ID=c.Job)" 
	valueColumn="ID"
	pageSize="20" 
	useSnapshot="true" 
	caption="Задачи в работе или завершены" 
	orderByClause="a.dCreate Desc,c.dBeg,c.dEnd"
	onselectrow='zenPage.Select(zenThis.getValue("ID"))'
	ondblclick='zenPage.Edit(zenThis.getValue("ID"));' 
	showQuery="true"
>

<column 
	header="Квартал" 
	colName="Kvartal" 
	width="130px"
	colExpression="wrk.Plan_KvrToStr(b.Plan)"
	filterType="query"
	filterOp="="
	filterQuery="Select wrk.Plan_KvrToStr(ID) From wrk.Plan"
/>

SELECT TOP  101  
   a.ID ID,
   TO_CHAR(a.dCreate,'DD.MM.YYYY') dCreate,
   a.Title Title,
   wrk.Plan_KvrToStr(b.Plan) Kvartal,
   TO_CHAR(c.dBeg,'DD.MM.YYYY') dBeg,
   TO_CHAR(c.dEnd,'DD.MM.YYYY') dEnd 
FROM
   wrk.Task as a INNER JOIN wrk.Job as b ON (a.ID=b.Task)LEFT OUTER JOIN wrk.Stage as c ON (b.ID=c.Job) 
ORDER BY 
   a.dCreate Desc,c.dBeg,c.dEnd

SELECT TOP  101  
   a.ID ID,
   TO_CHAR(a.dCreate,'DD.MM.YYYY') dCreate,
   a.Title Title,
   wrk.Plan_KvrToStr(b.Plan) Kvartal,
   TO_CHAR(c.dBeg,'DD.MM.YYYY') dBeg,
   TO_CHAR(c.dEnd,'DD.MM.YYYY') dEnd 
FROM 
   wrk.Task as a INNER JOIN wrk.Job as b ON (a.ID=b.Task)LEFT OUTER JOIN wrk.Stage as c ON (b.ID=c.Job) 
WHERE 
   Kvartal = 'III квартал 2009' 
ORDER BY 
   a.dCreate Desc,c.dBeg,c.dEnd

   wrk.Plan_KvrToStr(b.Plan) = 'III квартал 2009'