1

We upgraded yesterday from 4.5.8 to 4.6.5 (with Drupal 7.38). We have a number of custom fields for Individuals which are type multi-select (child's grade in school, marital status, etc.). When we search on those fields from the Advanced search screen, the search yields no results. However, if I create the same search in Search Builder, I get results.

Search Builder example (this is the only search criteria):

Individual > Marriage:Marital Status > = > Widow/Widower

I get 16 results.

If I build that same search in Advanced search, I get 0 results.

Any ideas?

I turned on CIVICRM_DEBUG_LOG_QUERY per this post: How can I tell what the query that is executing when I do an Advanced Search looks like?. But, not knowing exactly what I was looking for in the log file, I can't tell what is amiss in the Adv Search.

1

This is fixed recently fixed against coming 4.6.6 code-base and here's the fix https://github.com/civicrm/civicrm-core/pull/6256/files and https://github.com/civicrm/civicrm-core/pull/6299/files

2

After you have made your advanced search and get no results, you will stay on the advanced search page.

If you look at the bottom of that page it will say "No matches found for:" and then list the options you have chosen. Can you see anything in there that wasn't related to the options you picked?

I only mention this as I have a similar problem and I can see that the "Preferred Language" field is being set to Afrikaans, so therefore making any advanced searches yield no results.

  • Thank you garethh for prompting me to think of other possible factors. I search through each of the other options to see if something was turning on when it wasn't supposed to (like your Preferred Language issue), but unfortunately, no such luck. I'm still not sure what's causing this. – Allen Hutchison Jul 24 '15 at 15:27
  • I agree that still there are lot of contact attributes e.g. preferred communication, world-region, email etc. failing in Search forms/get.Api. Can someone please create a issue for this, if possible list all the possible fields which are not working in Search Builder/Advance Search/custom searches!! Thanks – Monish Deb Jul 30 '15 at 12:41
0

This was resolved by reloading my 4.5.8 database and code then upgrading to 4.6.4. Not a proper solution because I still don't know why the search results differed, but effective for our production environment. When 4.6.6 comes out, I'll test to see if this is truly fixed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.