SQL Table Widget in Portal 7.02
I wrote a bunch of very simple queries, trying to build a maintenance dashboard for my analysts, which for some reason will not work in the SQL Table or Chart widget in the portal..anyone got any ideas? Here is my query
select wi.workitemid as 'ID', CONVERT(varchar,wi.created,101) as 'Created', RC.displaystring as 'Source'
from workitem as wi
left join CI$User as userTable on wi.affecteduserid = userTable.Id
inner join DisplayString as RC on (wi.sourceid = rc.elementid and rc.localeid = 'ENU')
where createdbyuser = 'First Last'
and wi.WorkItemId like 'IR%'
and rc.displaystring = 'Retired - Console'
and created > '11/01/2016'
ORDER BY WI.Created ASC