Home Analyst Portal

Problem with promoted Views

Adam_StoppaAdam_Stoppa Customer IT Monkey ✭
edited March 2021 in Analyst Portal

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.


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

Answers

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭

    @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_StoppaAdam_Stoppa Customer IT Monkey ✭

    Hi Justin,

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


    Thanks

    adam

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭

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

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


Sign In or Register to comment.