View with Workitems assigned to me

Martin_Strbavy

Hi,
I am trying to create new view for change requests, which will show only tickets assigned to me. In a console it is possible to use [me] tag, but it looks that it is not working in SSP. Is there some special way how to do that? Can someone guide me how to prepare this view for ssp? 

Thanks
Martin

Justin_Workman

You can create a SQL table widget and use the parameter @userid.  That will use the id of the logged in user so kind of like [me].  A simple query might look like this:
SELECT workitemid, title,assigneduser
FROM Workitem w
LEFT JOIN displaystring ds
ON ds.elementid = w.statusid
AND ds.localeid = 'enu'
WHERE assigneduserid = @userid AND workItemid like 'cr%' AND ds.displaystring = 'in progress'

Justin_Workman

Adding a SQL table widget:
https://support.cireson.com/KnowledgeBase/View/1291#/
Adding a dashboard page that can hold a SQL table widget:
https://support.cireson.com/KnowledgeBase/View/1297#/

Justin_Workman

You can create a SQL table widget and use the parameter @userid.  That will use the id of the logged in user so kind of like [me].  A simple query might look like this:
SELECT workitemid, title,assigneduser
FROM Workitem w
LEFT JOIN displaystring ds
ON ds.elementid = w.statusid
AND ds.localeid = 'enu'
WHERE assigneduserid = @userid AND workItemid like 'cr%' AND ds.displaystring = 'in progress'

Justin_Workman

Adding a SQL table widget:
https://support.cireson.com/KnowledgeBase/View/1291#/
Adding a dashboard page that can hold a SQL table widget:
https://support.cireson.com/KnowledgeBase/View/1297#/