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) »
  • Custom fields of type Note:RichTextEditor not searchable?
Pages: [1]

Author Topic: Custom fields of type Note:RichTextEditor not searchable?  (Read 711 times)

AudreyKate

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 1
  • CiviCRM version: 3.4.4
  • CMS version: Drupal 6.24
Custom fields of type Note:RichTextEditor not searchable?
September 26, 2010, 03:20:06 pm
Hello!

Is it not possible to search in custom data fields of data type "Note" when the input type is "RichTextEditor"?

On both my personal site and the demo site, I get hits when searching in Note:TextArea fields, but searching in Note:RichTextEditor fields never returns any hits, even when I enter only a single word in the field and I search by that word.

Any help? On the demo site, I tested this by creating a Custom Field Set called "Custom Data Search" that contains one Note:RichTextEditor field, called "Testing Search." No matter what I enter into individual records, I can't get Advanced Search to spit anything out when I search in this field.

Is this one of the CKEditor bugs?

Audrey

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Custom fields of type Note:RichTextEditor not searchable?
September 27, 2010, 04:21:46 pm
I suspect this is due to the HTML tags that are included in custom field data created / updated via WYSIWYG editors. Try searching with the leading wildcard character (%). So if you're looking for results which include the word "fundraising" - put "%fundraising" in the search field.
Protect your investment in CiviCRM by  becoming a Member!

AudreyKate

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 1
  • CiviCRM version: 3.4.4
  • CMS version: Drupal 6.24
Re: Custom fields of type Note:RichTextEditor not searchable?
September 27, 2010, 11:48:13 pm
This does work, thank you for the suggestion!

Unfortunately, I would like our member bios to be html formatted and searchable from our public member database, and it's cumbersome to ask the casual site visitor to enclose their search terms in % marks.

Do you think I could use a hook to transform all searches for data in this bio field, so that the % marks are added automatically?

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Custom fields of type Note:RichTextEditor not searchable?
September 28, 2010, 10:15:37 am
I think the postProcess hook might work for this - but not sure.
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Custom fields of type Note:RichTextEditor not searchable?

This forum was archived on 2017-11-26.