Emailaddress -> Person Entity

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alasdaircr
    Active Community Member
    • Aug 2014
    • 525

    Emailaddress -> Person Entity

    I'm having trouble seeing the cleanest way to get all Person entities associated with a particular email address (usually this will just be one Person entity).

    I can get the emailAddressId, I just need a select on this, giving all [entityId, entityType] pairs.
  • paladin80
    Junior Member
    • Aug 2014
    • 11

    #2
    SELECT entity_id, entity_type
    FROM `entity_email_address`
    WHERE email_address_id = '53ec89eac199a'

    Comment

    • alasdaircr
      Active Community Member
      • Aug 2014
      • 525

      #3
      Of course I'd already figured out THAT approach

      Comment

      • yuri
        Member
        • Mar 2014
        • 8455

        #4
        There will the method that returns the first entity associated with a particular email address in the next version. A lot of improvements related to Emails is coming.
        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

        • alasdaircr
          Active Community Member
          • Aug 2014
          • 525

          #5
          Great to hear Yuri.

          Comment

          Working...