![]() |
#4 |
Участник
|
Добрый день!
Вот запрос на получение данных по кастомной сущности Код: select 'lead' as Entity, (select COUNT(wm_auditid) from Filteredwm_audit as audit where wm_entityname='lead' and createdon >= @periodStart and createdon<=@periodEnd and wm_typename='Create' and createdby in (@Managers)) as Created, (select COUNT(distinct wm_entityid) from Filteredwm_audit as audit where wm_entityname='lead' and createdon >= @periodStart and createdon<=@periodEnd and wm_typename='Update' and createdby in (@Managers)) as Modified, (select COUNT(distinct wm_entityid) from Filteredwm_audit as audit where wm_entityname='lead' and createdon >= @periodStart and createdon<=@periodEnd and wm_typename='Qualify' and createdby in (@Managers)) as Qualified, (select COUNT(distinct wm_entityid) from Filteredwm_audit as audit where wm_entityname='lead' and createdon >= @periodStart and createdon<=@periodEnd and wm_typename='Assign' and createdby in (@Managers)) as Assigned, (select COUNT(distinct wm_entityid) from Filteredwm_audit as audit where wm_entityname='lead' and createdon >= @periodStart and createdon<=@periodEnd and wm_typename='Assign' and wm_postvalue in (@Managers)) as AssignedTo, '0' as Closed, '0' as CreatedAmount, '0' as Payed, '0' as PayedAmount, '0' as Shipped, '0' as ShippedAmount Последний раз редактировалось drongo; 08.08.2012 в 12:04. |
|