2 votes
Accepted

Find Contacts Custom Searches Zip Code Range Search lists duplicates

Your question suggests you're using the Zip Code Range custom search - but this is a very old way to handle zip code range searches, from before Advanced Search could do them (10-12 years ago). In my ...
user avatar
2 votes
Accepted

DB Error: no such field "created_date"

Do you have logging turned on (admin - system settings - misc)? If so then the log table is probably out of sync. Check log_civicrm_relationship to see if it has the field. If it doesn't have the ...
user avatar
  • 17.5k
2 votes

Using API4 to get contact based on email match

So @Demerit's answer above was exactly what I needed to understand how to connect the two tables together (email table and contact info table). I am posting my answer for other noobs that are trying ...
user avatar
  • 289
1 vote
Accepted

Using API4 to get contact based on email match

Unless you have a complex join, it's simply a matter of referencing contact_id (the literal string prefix contact_id., not a numeric contact id) in the select() or where() to create the join, e.g. $x =...
user avatar
  • 17.5k

Only top scored, non community-wiki answers of a minimum length are eligible