Clarity

  • Private Community

  • 1.  Sysdate in Power filter

    Posted Nov 01, 2018 06:35 PM

    How can we use sysdate in power filter. I want to fetch a list with condition like datefield<=sysdate+90

     

    Is it possible with ca ppm?



  • 2.  Re: Sysdate in Power filter

    Broadcom Employee
    Posted Nov 02, 2018 03:43 AM

    Hi Uruj,

     

    You cannot use database functions in the powerfilter, however you can use the date field and in your NSQL you can add +90 and show the data.

     

    Regards

    Suman Pramanik 



  • 3.  Re: Sysdate in Power filter
    Best Answer

    Broadcom Employee
    Posted Nov 02, 2018 04:05 AM

    Hi UrujPruthiD,

     

    You maybe able to use dateMacro like as below.

     

    I don't have any document about dateMacro.

    It seems not to be documented. I don't know whether it is supported function or not.

     

    Regards,

    Shoichi



  • 4.  Re: Sysdate in Power filter

    Posted Nov 02, 2018 04:27 AM

    Some other datemacro options ; PowerFilter - dateMacro