Clarity

  • 1.  Portlet Filter

    Posted Jul 26, 2018 10:14 PM

    Hello All

    Is it possible to personalize what an user sees depending on their log in information? 

     

    Thanks in Advance

    Dhivya



  • 2.  Re: Portlet Filter

    Broadcom Employee
    Posted Jul 27, 2018 12:28 AM

    Hi dshyam,

     

    You can use "Set as Home" to make some page as default home page.

     

    Go to any page which you want to set it as default home, and click "Save as Home" like as below.

     

    Next time you login, you will see the page which you set as home as initial page (Home Page).

     

    Regards,

    Shoichi



  • 3.  Re: Portlet Filter

    Posted Jul 27, 2018 01:55 AM

    In addition to Shoichi's comment, there have been discussions around how to set the home page automatically, or by admins. Links to some of them below:

    Automate seting the User Home page 

    Clarity home page 



  • 4.  Re: Portlet Filter
    Best Answer

    Posted Jul 27, 2018 03:30 AM

    I think the question is more to do with auto-filtering a portlet based on the logged-in user?

     

    For NSQL based portlets you can code that into the NSQL using the @WHERE:PARAM:USER_ID@ construct to identify the current user. For object based portlet I don't think that there is a way.



  • 5.  Re: Portlet Filter

    Posted Jul 27, 2018 08:49 AM

    Thanks Dave, that is very helpful. 

    Thanks, Shoichi and Jeevan. 



  • 6.  Re: Portlet Filter

    Posted Jul 27, 2018 10:46 AM

    would you happen to have the query handy?



  • 7.  Re: Portlet Filter

    Posted Jul 27, 2018 11:03 AM

    "the query"?

     

    I can give you an example on what you would need to do to your query using the default example NSQL that the system uses - I've added the highlighted line;

     

    SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:R.FULL_NAME:RSRC@,
    @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:MR.FULL_NAME:MANAGER@,
    @SELECT:METRIC:USER_DEF:IMPLIED:COUNT(*):PROJECT_COUNT:AGG@
    FROM INV_INVESTMENTS I,
    SRM_RESOURCES R,
    SRM_RESOURCES MR,
    CMN_SEC_USERS U
    WHERE I.CREATED_BY = U.ID
    AND U.ID = R.USER_ID

    AND U.ID = @WHERE:PARAM:USER_ID@
    AND R.MANAGER_ID = MR.USER_ID
    AND @FILTER@
    GROUP BY R.FULL_NAME,
    MR.FULL_NAME
    HAVING @HAVING_FILTER@



  • 8.  Re: Portlet Filter

    Posted Aug 01, 2018 03:46 PM

    Thanks, David