Having the same problem as many with SD-26242. Can someone help me create a workaround query? The one that is having the problem is:
SELECT arcwo.WORKORDERID "Request ID",arcwo.CREATEDTIME "Created Time",arcwo.TITLE "Subject",arcwo.COMPLETEDTIME "Completed Time" FROM Arc_WorkOrder arcwo WHERE ((arcwo.TITLE LIKE '%dpm%') AND (((arcwo.CREATEDTIME >= datetolong('2011-01-01') AND ((arcwo.CREATEDTIME != 0) AND (arcwo.CREATEDTIME IS NOT NULL))) AND ((arcwo.CREATEDTIME <= 1311656399000) AND (((arcwo.CREATEDTIME != 0) AND (arcwo.CREATEDTIME IS NOT NULL)) AND (arcwo.CREATEDTIME != -1)))))