Announcement

Collapse
No announcement yet.

Report Complex Filter

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Report Complex Filter

    Hi

    I'm trying to setup a filter in a report that compares two dates with each other, but I keep receiving an error, I'm not sure how the expression should be. Please see an example attached

  • #2
    Hi,

    Such are expressions not supported. Formula can not handle record values in this case.

    You can create not storable field that will calculate difference between two columns and then it can be utilized in the filter.

    Comment


    • #3
      That would be perfect, could you point me towards an example of such a field (non storable and calculated by other values)?

      Comment


      • #4
        It seems that I should mark it as notStorable within the entityDef, and then set a value within the Service's loadAdditionalFields method, is that correct?

        Comment


        • #5
          Try this way
          https://forum.espocrm.com/forum/gene...2-float-fields

          Comment


          • #6
            Awesome, thanks Tanya and Yuri

            Comment

            Working...
            X