Problem with promoted Views

Adam_Stoppa

Hi,

i created a View in SCSM concole with combinated class to show my own created SRs and my own created Incidents. The SCSM console show the view correctly. I promoted the view but the Web but the same View in Webportal doesn show anything.

My goal is to display my created Service Requests and Incidents.

Screenshot 2021-03-01 144104.png

I've noticed that the problem started since we switched to Windows Authentication. The view has this xml-code:

<Expression>

<SimpleExpression>

<ValueExpressionLeft>

<GenericProperty Path="$Context/Path[Relationship='Alias_945d98a31ba6484199ba60d8cb584f1e!System.WorkItemCreatedByUser']$">Id</GenericProperty>

</ValueExpressionLeft>

<Operator>Equal</Operator>

<ValueExpressionRight>

<Token>[ME]</Token>

</ValueExpressionRight>

</SimpleExpression>

</Expression>

😀

I found the answer by myself: https://support.cireson.com/KnowledgeBase/View/31#!/

Justin_Workman

@Adam_Stoppa - As an alternative, you could do a SQL table widget on a dashboard page. There is a token you can use in SQL queries in the portal. I believe this query will get close to what you're after:

SELECT 

WorkItemId, 

Title, 

sds.DisplayString as 'Status',

AffectedUser,

AssignedUser,

ts.DisplayString as 'SupportGroup',

LastModified

 FROM WorkItem wi

  

 join DisplayString sds 

 on sds.ElementID = wi.statusid

 and sds.LocaleID = 'enu'

 join DisplayString ts 

 on ts.ElementID = wi.TierId

 and ts.LocaleID = 'enu'

 where CreatedByUserId = @UserId

 and sds.DisplayString not in ('Closed', 'Resolved', 'Completed')

Adam_Stoppa

Hi Justin,

can you explain me how i do this SQL table widget on a dashboard page?

Thanks

adam

Justin_Workman

@Adam_Stoppa - Here's a link to an article on adding a SQL table widget:

https://kb.cireson.com/article/how-to-add-an-sql-table-widget/1291

You might check out this article too for adding a dashboard page:

https://kb.cireson.com/article/how-to-add-and-edit-a-dashboard-page/1297