Posted 9 September 2017, 8:29 am EST
Hi,I am trying to work out the best way of displaying date range information in Lightswitch.
I have a table of requests and a RequiredDate field. I have created a query in LS query builder to filter the date range I want. Say this month... But I want to see all days of the month, not just the ones where I have a request. So if there are no requests due on the 19-Sep I want it to display 0 rather than leave it out of the chart. What is the best way to acheive this?
I have created a view with a left outer join to a calendar table in SQL (to supply me with all of the dates in the range) and used it in LS, but this seems really messy and not very flexible. I would prefer to use LINQ in LS if possible. But I do not have much knowldge of LINQ.
What is the best way to use a date range chart with the C1 chart tool?
Regards
Steve Kent