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) »
  • Invisible values in custom fields
Pages: [1]

Author Topic: Invisible values in custom fields  (Read 426 times)

FastPhil

  • I’m new here
  • *
  • Posts: 23
  • Karma: 1
  • CiviCRM version: 4.04
  • CMS version: Drual 7
  • MySQL version: 5.154
  • PHP version: 5.3.5
Invisible values in custom fields
April 17, 2012, 08:47:40 am
Drupal 7 Civi 4.0.7  I have a custom field in my database that should be blank or contain the words Erie, Huron or Michigan. The records that should be blank appear to be blank but when using search builder     
Contact Type - 'Individual' ...AND...
LodgeNum = 244 ...AND...
Enrollment Level - Initial IS NULL 

I get 140 records

   
Contact Type - 'Individual' ...AND...
LodgeNum = 244 ...AND...
Enrollment Level - Initial < Erie

I get 47 records

   
Contact Type - 'Individual' ...AND...
LodgeNum = 244

I get 278 records and I have 91 records with Erie in it.  Any idea what might be in the other records and how I can fix it?

Thank You!

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: Invisible values in custom fields
April 17, 2012, 12:07:33 pm

I would look at the mysql query logs and see the queries generated. That way u can potentially track things down

Note that search builder is not actively supported in CiviCRM. We are looking for some volunteers to take over that functionality

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) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Invisible values in custom fields

This forum was archived on 2017-11-26.