I'm looking for a bit of reassurance before reporting a bug(s) in the search builder. On my own site, we have a custom field 'Course Code' which we've previously used for regex searches in the search builder.

However, recently (or since this time last year!) it seems to be broken. I'll attach a series of screenshots below to illustrate my point.

I have attempted to reproduce on the CiviCRM Demo site by searching in Search Builder using regex for the postal code field. It seems to broken there too. Screnshot at bottom of page.

To summate, am I being an idiot, or is the regex search in search builder broken?

Searching by both contact subtype and regex Searching by regex and contact subtype Gives us no results.

Searching by regex only Searching by regex only Gives us an expected result

Searching by subtype only Searching by subtype only Again gives us an expected result

Searching by a regex for the year Searching by a regex for the year Brings up expected results

Searching by regex for year and a text value **Searching by regex for year and a text value** Theoretically, this should work, and has done in the past. Doesn't now.

CiviCRM Demo Site CiviCRM Demo Site broken too There are plenty of 5-digit postal codes in the contact database starting with 7.

  • Is working here....I'm using 5.6.1. Make sure you have the correct address type for the post code. BTW starting with 5 would be ^5 in regex. But you should still get something just with the 5 – Tony Horrocks Nov 17 '18 at 15:11
  • After a bit more experimentation, my site is fine with using numbers, but when I add a letter into the string, it breaks. – termdark Nov 18 '18 at 22:22
  • Tried on 5.8.alpha1 and it seems ok. Might be worth double checking that you are looking for the right location. Your screenshot shows searching for Home but if your postcodes with letters are eg Billing then they won't show up. – Aidan Nov 19 '18 at 11:43

Your Answer

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

Browse other questions tagged or ask your own question.