I previously reported an issue with the slow performance of the Blazor version so have now moved on to using the JS version which is going well at the moment aside from a small issue.
If we use the following SQL in the query as an example:
Code: Select all
Select h.Id as hid,t.Name as Template, cast(h.__InsertTimestamp as INT) as SurveyNumber
--SITE DETAILS
,Max(CASE WHEN q.Name = 'HiddenSite' THEN a.[Value] END) AS [SiteName]
FROM Table
Code: Select all
Select h.Id as hid,t.Name as Template, cast(h.__InsertTimestamp as INT) as SurveyNumber --SITE DETAILS ,Max(CASE WHEN q.Name = 'HiddenSite' THEN a.[Value] END) AS [SiteName] FROM Table
Is there any way to get around this issue?
Regards,
Russell