SQL Table Widget Column Headings
Been racking my brains this afternoon trying to work out what's going on.
I have the following query which I plan on using with a customer who needs a team work view with some additional fields on
Select w.WorkItemId as [Id], w.Title as [Title],dstat.DisplayString as [Status],dtier.DisplayString as [Support Group],w.AffectedUser as [Affected User],w.AssignedUser as [Assigned To User],affu.Department as [Department],w.Created,w.LastModifiedfrom WorkItem wINNER JOIN DisplayString dstat on w.StatusId = dstat.ElementID AND dstat.DisplayString NOT IN ('Failed', 'Resolved', 'Closed', 'Completed', 'Cancelled', 'Skipped')Left JOIN CI$User affu on w.AffectedUserId = affu.IdLEFT JOIN DisplayString dtier on w.TierId = dtier.ElementIDwhere AssignedUserId = @UserId OR TierId IN (Select sg.EnumerationId from SupportGroupMapping_CI$DomainGroup_Enumeration sgINNER JOIN CI$DomainGroup g ON g.Id = sg.DomainGroupIdINNER JOIN GroupMembership_CI$DomainGroup_CI$User m ON m.DomainGroupId = g.Id AND m.UserId = @UserId AND g.Analyst = 1)
1) the headings aren't coming through correctly (i.e. spaces removed etc)
2) the dates aren't formatting as per the rest of the portal (I've made an assumption here that the portal will sort date translations out, if not then I'll adjust via SQL)
3) the $('[data-role=grid]').data('kendoGrid').dataSource.read(); method to refresh the data doesn't appear to work so I can't setup an auto refresh for the page
Any ideas on how to solve the above?