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) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • Should Custom Data fields default to be Searchable

Poll

Currently the default setting is that Custom Data fields are NOT searchable, should this be changed so that the default is that they ARE searchable

Yes change the default so Custom Data fields are Searchable
1 (100%)
Leave default as NOT searchable
0 (0%)
It is about 50/50 in our use cases
0 (0%)

Total Members Voted: 1

Voting closed: April 06, 2011, 12:23:00 pm

Pages: [1]

Author Topic: Should Custom Data fields default to be Searchable  (Read 1008 times)

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Should Custom Data fields default to be Searchable
April 01, 2011, 12:23:00 pm
Not sure I see polls being used much on the forum but thought I would give this a whirl as a way to get feedback. Personally I am for ever having to remind myself to make Fields searchable, or having to explain to clients that the reason they can't find fields in Adv Search is that they didn't make them Searchable. Alternatively maybe a bit of HELP text on the Adv Search screen to explain that fields can be configured to be available or removed.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

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: Should Custom Data fields default to be Searchable
April 01, 2011, 03:00:50 pm

in general making all fields searchable is a very bad idea from a database perspective. Indexes take space (and i think there is  a finite limit to how many u can have per table) and also slow down inserts/updates

If this is set by default, then i suspect most people will not bother to reset them and hence potentially hit some of the issues above. At the least we should figure out what are the consequences of making all columns in a table indexable

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) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • Should Custom Data fields default to be Searchable

This forum was archived on 2017-11-26.