Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-7001

Custom data Booleans do not honor default No

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 3.2.4
    • Fix Version/s: 4.3.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      Create a Yes/No field in a custom field set. Put zero for the default value (i.e. No).

      Check existing record, or create new record: the default is NULL not 0.

      The NULL is not always relevant (e.g. my current application of this is "Is child deceased?") - it would be better if the default was honoured as otherwise it's opening up to significant data entry errors (oops I clicked Yes).

      This behaviour is shown in 3.2.3 (my install) and v29810 on the demo site.

      Also, any reason why such booleans are implemented as a 4-byte signed integer? Surely BOOLEAN? or unsigned tinyint(1) or even ENUM('No','Yes')?

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              artfulrobot.com Rich Lott
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: