Good day,
I have matrix report that shows count of workorders per place and per technician group.
Everything was fine until some day. Now I look at the report and see some strange conditions in SQL query.
SELECT sdo.NAME "Площадка",qd.QUEUENAME "Группа",wo.WORKORDERID "ID заявки" FROM WorkOrder wo LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE (((((std.STATUSNAME = N'В ожидании' COLLATE SQL_Latin1_General_CP1_CI_AS) OR (std.STATUSNAME = N'На согласовании' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (std.STATUSNAME = N'Открыто' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (std.STATUSNAME IS NULL))
AND ((wos.OWNERID = 13) OR (wo.REQUESTERID = 13))) AND wo.ISPARENT='1'
I wonder why this string is added? I don't have any conditions except status of workorder.
That string limits results that I recieve.
Thanks in advance.