Announcement

Collapse
No announcement yet.

How to properly specify a complex filter for report?

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

  • 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:	485
Size:	6.8 KB
ID:	48345

  • #2
    You should select "Expression" in the top dropdown.

    Comment


    • #3
      this dropdown ?

      Comment


      • #4
        I think you have not up to date advanced pack.

        Comment


        • #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


          • #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


            • #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...
              X