I am trying to create a report in fusion to show me all the hours that have been billed between two dates. The 19th of the month. So far the query I have constructed is as follows:
SELECT SUM('Ticket Billing.Time Spent'), SUM('Ticket Billing.Time Billable') FROM 'Ticket Billing', 'Tickets', 'Users' WHERE 'Ticket Billing.Creation Date' created >= '2015-06-19' AND created <= '2015-05-19' AND 'Ticket Billing.Worker' = 'Support' GROUP BY 'Ticket Billing.Creation Date':DayName ORDER BY 'Ticket Billing.Creation Date'
This is not working and I get an error:
Expected end of query or clause, got created at offset 156
I believe it is to do with the creation date?? Any advise?
Video and slides from this week's Monday Night Special are online. Learn more about the differences between Atlassian Server/Data Center and Atlassian Cloud from Daniel Meisen, kreuzwerker, and find ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event