SQL table Widget problem?

Magnus_Lundgren1

When i use a SQL table widget i cannot click any of the results. when i do i get redirected to the search page. is this by design or am i doing somthing wrong?

heres an example

<div>SELECT TOP 2500 wi.WorkItemId ID, wi.Title, wi.AssignedUser</div><div>FROM [WorkItem] wi</div><div>WHERE wi.ClassId = '422afc88-5eff-f4c5-f8f6-e01038cde67f' AND wi.StatusId IN('720438eb-ba08-1263-0944-6791fcb48991')</div>

Brian_Wiest

Minor update

SELECT wi.WorkItemId as Id, wi.Title, wi.AssignedUser, LEFT(CONVERT(varchar, wi.Created,126),10) Skapad

FROM [WorkItem] wi

WHERE wi.ClassId = '422afc88-5eff-f4c5-f8f6-e01038cde67f' AND wi.StatusId IN('720438eb-ba08-1263-0944-6791fcb48991')

Brian_Wiest

I ran into the same issue
Update line

wi.WorkItemId as<span> [Id]
Using ID causes issues with the row click action.</span>

Magnus_Lundgren1

Same, tried

<div>SELECT wi.Title, wi.AssignedUser, LEFT(CONVERT(varchar, wi.Created,126),10) Skapad</div><div>FROM [WorkItem] wi</div><div>WHERE wi.ClassId = '422afc88-5eff-f4c5-f8f6-e01038cde67f' AND wi.StatusId IN('720438eb-ba08-1263-0944-6791fcb48991')</div>

Brian_Wiest

Minor update

SELECT wi.WorkItemId as Id, wi.Title, wi.AssignedUser, LEFT(CONVERT(varchar, wi.Created,126),10) Skapad

FROM [WorkItem] wi

WHERE wi.ClassId = '422afc88-5eff-f4c5-f8f6-e01038cde67f' AND wi.StatusId IN('720438eb-ba08-1263-0944-6791fcb48991')

Magnus_Lundgren1

Like a glove!

Thanks