Reporting "Contains"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bgpus
    Junior Member
    • Dec 2020
    • 6

    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?
  • Maximus
    Senior Member
    • Nov 2018
    • 2731

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