I have a requirement in which i need to show a count of new and closed items for each day. I executed following OQL SELECT distinct sum(case when Case_Status!='Closed' then 1 else 0 end) as NoOfNewCases, sum(case Case_Status when 'Closed' then 1 else 0 end)as NoOfClosedCases, changedDate from MyFirstModule.Case_Details group by changedDate I have given the changedDate column in horizontal axis. As you can see below, the date is repeated. Can somebody help me with this.?
asked
shruthi bhatt
1 answers
0
Since the changedDate consist of a date part and a time part you are seeing the multiple dates. You should group it only on the date part, but I wonder how you could do this in OQL. I would create a new Date object and attach all the objects you want to count on to that date object. You can then show that date object in OQL and still use the filters.