Добрый день!
Вот запрос на получение данных по кастомной сущности
Код:
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
@Managers, @periodStart, @periodEnd - это параметры отчета.