View with Workitems assigned to me

Martin_Strbavy · January 2019

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 · January 2019

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 · January 2019

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 · January 2019

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 · January 2019

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#/

View with Workitems assigned to me

Best Answers

Answers

View with Workitems assigned to me

Best Answers

Answers

CIRESON COMMUNITY WEB SITE