Проблема с отчетом при смене языка в настройках системы

[drongo]

Добрый день!

Вот запрос на получение данных по кастомной сущности

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 - это параметры отчета.

[Bondonello]

Попробуйте в query заменить значения OptionSet с имен на цифры
вместо wm_typename='Update' написать wm_type=1

[drongo]

Цитата:

Сообщение от Bondonello

Попробуйте в query заменить значения OptionSet с имен на цифры
вместо wm_typename='Update' написать wm_type=1

Спасибо, это решило проблему