Announcement

Collapse
No announcement yet.

Reporting "Contains"

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

  • Reporting "Contains"

    I'm looking to pull a report on address that contain x, y, or z Postal Codes. I have about 90 codes I'd like to pull from. Is there a faster way to achieve this rather can creating 90 individual OR filters?

  • #2
    Hello,
    You can utilize Complex Expression https://docs.espocrm.com/user-guide/...xpressions/#in (see screenshot).

    Note:
    - 'billingAddressPostalCode' is the Postal Code field in the Account entity. Please check your Postal Code field key in Entity Manager.
    - '1' & '2' are test post code in different Account's entries.
    Attached Files

    Comment

    Working...
    X