CiviCRM Community Forums (archive)

Use case: profile search to allow anonymous users to search a public directory of organizations, showing a subset of fields for a subset of the orgs in the Civi db. The orgs have their full name in the Organization Name field; some also have an acronym in the Nickname field. Users are to be able to search by either full name or acronym using a single field on the search form.

The neatest solution would seem to be for the profile search to respect the Include Nickname setting in Global Settings - Miscellaneous, so that a profile search on Organization Name also searches the Nickname field, if Include Nickname is checked. Is this feasible?

More generally, it would be great to have a general content search available in profiles (or in some other form not requiring the user to have access to the full Civi interface). Here are some ideas for how this might work:

• New profile URL, e.g. "civicrm/profile/general?reset=1&gid=N" provides a search form for that profile with a single search box instead of one per searchable field. The box searches all of the fields that are configured as searchable in that profile.
  
• New setting in Profile Settings: Enable General Search. Provides a general search box on the profile search form that searches all searchable fields.

Another approach might be to expose the desired fields from the desired contacts to the UF's (e.g. Drupal's) general search mechanism, thus taking advantage of indexing, stemming etc. Did Civinode allow this sort of thing? I use the past tense as the last version on drupal.org is for Drupal 5, Sep 2007.

Dave J

Thanks for the reply, Lobo. I've had a look at the views2 integration and although it looks like a promising alternative direction for Civi/Drupal integration, it seems to fall short at the moment re present use case on several counts:

• filter by contact name or nick name does not work: rather than a text field it presents a drop-down with Yes / No / Any, which inserts a WHERE clause such as "WHERE civicrm_contact.display_name in ('0')"
• as with profile searches, views filters relate to a single field.
• doesn't support custom fields (realise I didn't mention these but the profile also has search/view  custom fields)

So I don't think it helps with this use case.

Getting profile search to respect the Include Nickname setting struck me as a nice solution, so that profile search behaves consistently with Find Contacts. I don't know how much of the search code is shared between profile search and Find Contacts - is this a big job?

Thanks again, Dave J.

I had a look at the code in CRM/Contact/BAO/Query.php relating to includeNickNameInName and noticed that it occurs in function sortName. I tried using the sort_name field in the profile instead of organization_name and ta-da, it works: if Include Nickname is set, both organization_name and nick_name are searched. 

Dave J