CREATEDTIME
Hi.
I'm from Russia.
Sorry for my English
There is a standard query that shows outstanding requests for the current day:
VICEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID LEFT JOIN RequestResolution rrs ON rrr.REQUESTID=rrs.REQUESTID WHERE (((((serdef.NAME = N'КХ НСИ' COLLATE Cyrillic_General_CI_AS) AND ((std.STATUSNAME = N'Открыто' COLLATE Cyrillic_General_CI_AS) OR (std.STATUSNAME = N'Пауза' COLLATE Cyrillic_General_CI_AS))) AND (((wotodesc.FULLDESCRIPTION NOT LIKE N'%Адаптер Сапфир%' COLLATE Cyrillic_General_CI_AS) AND (wotodesc.FULLDESCRIPTION NOT LIKE N'%не был передан в LK%' COLLATE Cyrillic_General_CI_AS)) OR (wotodesc.FULLDESCRIPTION IS NULL))) AND ((wo.TITLE LIKE N'%Элемент попал в каскады%' COLLATE Cyrillic_General_CI_AS) OR (wo.TITLE LIKE N'%Адаптер вернул ошибку при получении сообщения от НСИ%' COLLATE Cyrillic_General_CI_AS))) AND (((wo.CREATEDTIME >= 1477944000000) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1478030399000) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1))))) AND wo.ISPARENT='1'
Please help me to create a report that displays the application date was 5 hours one day and 5 hours another day.
I'm from Russia.
Sorry for my English
There is a standard query that shows outstanding requests for the current day:
VICEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID LEFT JOIN RequestResolution rrs ON rrr.REQUESTID=rrs.REQUESTID WHERE (((((serdef.NAME = N'КХ НСИ' COLLATE Cyrillic_General_CI_AS) AND ((std.STATUSNAME = N'Открыто' COLLATE Cyrillic_General_CI_AS) OR (std.STATUSNAME = N'Пауза' COLLATE Cyrillic_General_CI_AS))) AND (((wotodesc.FULLDESCRIPTION NOT LIKE N'%Адаптер Сапфир%' COLLATE Cyrillic_General_CI_AS) AND (wotodesc.FULLDESCRIPTION NOT LIKE N'%не был передан в LK%' COLLATE Cyrillic_General_CI_AS)) OR (wotodesc.FULLDESCRIPTION IS NULL))) AND ((wo.TITLE LIKE N'%Элемент попал в каскады%' COLLATE Cyrillic_General_CI_AS) OR (wo.TITLE LIKE N'%Адаптер вернул ошибку при получении сообщения от НСИ%' COLLATE Cyrillic_General_CI_AS))) AND (((wo.CREATEDTIME >= 1477944000000) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1478030399000) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1))))) AND wo.ISPARENT='1'
Please help me to create a report that displays the application date was 5 hours one day and 5 hours another day.