Constituent Search API Not returning result for Constituent Organization long name record and for Constituent Individual record which contains middle name

Hardik Hapani

Constituent Search API: Not able to get Constituent record on below mentioned cases: 


Issue 1: Issue with Organization record whose name has two or more strings in its name

ALDORA ALUMINUM & GLASS PRODUCTS INC - This is Constituent Organization record.

When we are searching record with string 'ALDORA ALUMINUM' or 'ALDORA ALUMINUM & GLASS PRODUCTS INC' its not returning result.

Issue 2: Issue with Individual record whose name has middle name and last name

Allison E. Andrews -> This is Constituent Individual record With First Name, Middle Name, Last Name. When we are searching record with string 'Allison E.' its not returning result



Looking forward to get solution on this.

Thank you

Steven Cinquegrana

Hi Hardik‍.


With Issue1, I have a feeling that you'll draw a blank because the search field list (first name, last name, preferred name, former name, alias, email address, phone number, address, and lookup ID) doesn't include name which is the container field for organization names. The mapping on this is described in the GET Constituent schema: "If the constituent's type is Individual, this computed field indicates the full name of the constituent based on the target organization’s display name settings. If the type is Organization, this is the organization's name."


Regarding Issue 2, I think it's possible that the search is trying to match the full string "Allison E." on either first middle or last name (and probably address, etc), despite the note "Name combinations, such as first name and last name or preferred name and last name, are valid" but note that middle name is not included in the search field list.


Maybe try searching on only "Allison" - what happens then?


As you might have gleaned from this, Constituent Search has been very weirdly implemented (IMHO) and its behavior is often quite unintuitive.


Cheers,

Steve Cinquegrana | CEO and Principal Developer | Protégé Solutions