Home Analyst Portal

SQL table Widget problem?

Magnus_Lundgren1Magnus_Lundgren1 Customer Adept IT Monkey ✭✭
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>

Best Answer

Answers

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    I ran into the same issue
    Update line
    wi.WorkItemId as<span> [Id]
    Using ID causes issues with the row click action.</span>
  • Magnus_Lundgren1Magnus_Lundgren1 Customer Adept IT Monkey ✭✭
    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>
  • Magnus_Lundgren1Magnus_Lundgren1 Customer Adept IT Monkey ✭✭
    Like a glove!

    Thanks :smiley:
Sign In or Register to comment.