Home Analyst Portal
Options

My Requests page from Portal

Jim_LeJim_Le Customer IT Monkey ✭
edited June 2017 in Analyst Portal

Hello,

How can I duplicate My Requests page from Portal?

Thanks!

Jim Le

Answers

  • Options
    john_doylejohn_doyle Cireson Support Ninja IT Monkey ✭✭✭✭
    I don't understand the question. You want two identical My Requests pages in the Portal?
  • Options
    Jim_LeJim_Le Customer IT Monkey ✭
    Yes, we want to duplicate it first and then modify it by adding another column to it for CreatedBy. will it work that way? Thanks!
  • Options
    Geoff_RossGeoff_Ross Cireson Consultant O.G.
    @Jim_Le

    I think the best way to achieve this would be to create a Custom Page using Cireson Analytics and then add a single SQL table widget - thats the easy part.

    Then you just need a SQL query that brings in the data you need, eg the right columns including the CreatedBy and then finally add a filter on the end to only being requests 'belonging' to the logged on user. You'll need 
    WHERE AffectedUserId = @UserId
    NB, this will only work on the very latest version of the Cireson Portal.

    Good Luck.
Sign In or Register to comment.