В обычном отчете не отображаются записи с ID больше 9999
Добавлено: 19 дек 2023, 16:50
В сущности - создаются, в отчете - не отображаются.
Предложения, сообщения об ошибках, помощь!
https://forum.rukovoditel.net.ru/
Отчеты->Стандартные отчетыКакой тип отчета?
Код: Выделить всё
select e.* , (( (select SUM((func100.field_247*func100.field_248 /* if(func100.field_2430,func100.field_2430,func100.field_247*func100.field_248)*/)+0) from app_entity_27 func100 where func100.id>0 and func100.parent_item_id=e.id ) )+(e.field_563+e.field_863+( (select SUM((if(func100.field_2414,func100.field_2414,round(func100.field_248*func100.field_1804/100,-1)))*func100.field_247+0) from app_entity_27 func100 where func100.id>0 and func100.parent_item_id=e.id ) )+e.field_873+e.field_886)-( (select SUM(func100.field_2428+0) from app_entity_27 func100 where func100.id>0 and func100.parent_item_id=e.id ) )-e.field_1193) as field_284, (if( (select SUM(((select fcv.value from app_fields_choices fcv where fcv.id = func100.field_1207)*func100.field_1209)+0) from app_entity_79 func100 where func100.id>0 and func100.parent_item_id=e.id ) , (select SUM(((select fcv.value from app_fields_choices fcv where fcv.id = func100.field_1207)*func100.field_1209)+0) from app_entity_79 func100 where func100.id>0 and func100.parent_item_id=e.id ) ,0)) as field_877, ((( (select SUM((func100.field_247*func100.field_248 /* if(func100.field_2430,func100.field_2430,func100.field_247*func100.field_248)*/)+0) from app_entity_27 func100 where func100.id>0 and func100.parent_item_id=e.id ) )+(e.field_563+e.field_863+( (select SUM((if(func100.field_2414,func100.field_2414,round(func100.field_248*func100.field_1804/100,-1)))*func100.field_247+0) from app_entity_27 func100 where func100.id>0 and func100.parent_item_id=e.id ) )+e.field_873+e.field_886)-( (select SUM(func100.field_2428+0) from app_entity_27 func100 where func100.id>0 and func100.parent_item_id=e.id ) )-e.field_1193)-(if( (select SUM(((select fcv.value from app_fields_choices fcv where fcv.id = func100.field_1207)*func100.field_1209)+0) from app_entity_79 func100 where func100.id>0 and func100.parent_item_id=e.id ) , (select SUM(((select fcv.value from app_fields_choices fcv where fcv.id = func100.field_1207)*func100.field_1209)+0) from app_entity_79 func100 where func100.id>0 and func100.parent_item_id=e.id ) ,0))) as field_878 from app_entity_26 e where e.id>0 and (e.field_282 not in (73,75) and (FROM_UNIXTIME(e.field_240,'%Y-%m')=date_format(DATE_ADD(now(),INTERVAL 0 MONTH),'%Y-%m'))) and e.parent_item_id in (select item_id from (select e.id as item_id ,IFNULL((select SUM(((select fcv.value from app_fields_choices fcv where fcv.id = msq.field_1207)*(msq.field_1209+0))) from app_entity_79 msq where msq.field_1206=366 AND e.id=msq.field_1210 limit 1),0) as field_1224 from app_entity_28 e where e.id>0 ) as parent_entity_28 ) order by e.field_283 desc limit 0, 30
[0.0867]
Думаете стоит фильтр на 10000 записей?будет видно какие фильтры используются в отчете