Clarity

  • Private Community

  • 1.  @WHERE:SECURITY for portfolio

    Posted Jun 07, 2017 11:59 AM

    Just like we have for project, can we have this for portfolio?

     

    @WHERE:SECURITY:PORTFOLIO:i.id@ - tried to use this, but it says undefined

     

    NJ



  • 2.  Re: @WHERE:SECURITY for portfolio
    Best Answer

    Posted Jun 13, 2017 03:05 PM

    @WHERE:SECURITY:PFM_PORTFOLIO:p.id@

     

     

    i.e.

    SELECT   @SELECT:DIM:USER_DEF:IMPLIED:PORT:p.id:id@,
             @SELECT:DIM_PROP:USER_DEF:IMPLIED:PORT:p.name:name@
    FROM
    PFM_PORTFOLIOS P
    WHERE @FILTER@
    AND @WHERE:SECURITY:PFM_PORTFOLIO:p.id@


  • 3.  Re: @WHERE:SECURITY for portfolio

    Posted Jun 14, 2017 01:26 AM

    Brilliant

     

    Thank you, Andrew

     

    Regards

    NJ