Expand all | Collapse all

Date Field in Power Filter -Error

Jump to Best Answer
  • 1.  Date Field in Power Filter -Error

    Posted 07-29-2014 02:37 AM

    Hello Everyone,


    I am facing some strange issue.When ever I am adding the date field in power filter(project or idea), evaluation is working fine but when I click on save and return I am getting System Error.I am facing this issue only in Production not in other environments.Did anyone faced the similar issue, if Yes do you have any solutions for me. Thanks in advance


    Clarity Version:V13.3


    Project Power Filter :project.schedule_start == date("2014-07-01T00:00:00") resulted in error.





  • 2.  Re: Date Field in Power Filter -Error

    Posted 07-30-2014 10:49 AM

    What is the error in the logs ?



  • 3.  Re: Date Field in Power Filter -Error

    Posted 07-31-2014 07:27 AM

    project.schedule_start == date("2014-06-01T00:00:00")

    works for me in v13.3 Sandbox. Don't see a difference  in  the format.

    Which browser?

    Restart browser and depending on the error in the log maybe also the app service.

  • 4.  Re: Date Field in Power Filter -Error
    Best Answer

    Posted 07-31-2014 10:03 PM

    Thanks NJ & Urmas. Unfortunately it ended up being a defect in clarity which does not have fix at this moment, and workaround is to add date field into normal filter of list page rather than power filter.


    Strangely it happens only for few cases not for all and we are one of them


    CLRT-67499: which indicates if adding date type field into power filer,Clarity sometimes throws out system error in GUI as well as "ORA-01861:literal does not match format string" error in log.