How to properly specify a complex filter for report?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tothewine
    Active Community Member
    • Jan 2018
    • 373

    How to properly specify a complex filter for report?

    I want to filter leads where two fields are different (i want addressPostalCode =\= capName), but I always get expression error 500. I am not sure where to put the complex expression in the report editing page...
    Click image for larger version

Name:	sC0lTy2.png
Views:	492
Size:	6.8 KB
ID:	48345
  • yuri
    Member
    • Mar 2014
    • 8440

    #2
    You should select "Expression" in the top dropdown.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • tothewine
      Active Community Member
      • Jan 2018
      • 373

      #3
      this dropdown ?

      Comment

      • yuri
        Member
        • Mar 2014
        • 8440

        #4
        I think you have not up to date advanced pack.
        If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

        Comment

        • tothewine
          Active Community Member
          • Jan 2018
          • 373

          #5
          Yeah, that seems to be the case (my boss not providing me upgraded packs). Could you show me how to apply the filter in that version?
          Thansk

          Comment

          • bandtank
            Active Community Member
            • Mar 2017
            • 379

            #6
            tothewine Did you ever figure this out? I am using an older advanced pack as well and I can't figure out how to form an expression using the available dropdowns and script area. I'm trying to filter reports if one date is after another, but nothing I've tried has worked.

            Comment

            • tothewine
              Active Community Member
              • Jan 2018
              • 373

              #7
              It's still on my backlog, so nothing practical. I had begun considering customizing the filtering logic with php, tough.
              Obviously the proper way should be to upgrade, but with the pack splitting it became more difficult to convince the higher ups to acquire it.
              Last edited by tothewine; 12-16-2019, 01:31 AM.

              Comment

              Working...