CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Searching by location, where this may be distinct from "Primary Address"
Pages: [1]

Author Topic: Searching by location, where this may be distinct from "Primary Address"  (Read 413 times)

michael_whitall

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Drupal
  • MySQL version: 7.14
  • PHP version: 7.14
Searching by location, where this may be distinct from "Primary Address"
July 11, 2012, 11:27:28 am
What I want to be able to do is search individual records based on the postcode or region in which they live.  Many records in our database have two addresses specified, one for where they're actually based, and one for a postal forwarding address (e.g. students' parent's addresses).  Several different address types are used in our system (e.g. home, work, uni, main), but which address to send postal mailings to for each record is specified using the "Primary Address" tick-box.  This means that, if I want to search for people who actually live in a given region or postcode, I have to search all five-or-so address-types separately, with an extra search term to exclude forwarding addresses.  This gets incredibly tedious, especially if I want to search over multiple postcodes as well.  Any ideas about how to make these location-based searches more succinct to carry out?


Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Searching by location, where this may be distinct from "Primary Address"
July 11, 2012, 11:34:28 am

might want to consider writing a custom search as described here:

http://book.civicrm.org/developer/the-extensions-framework/custom-searches

i've asked the book maintainer to fix the broken images on that page

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Searching by location, where this may be distinct from "Primary Address"

This forum was archived on 2017-11-26.