'title' => ts('Custom Field ID'),
'description' => ts('Unique Custom Field ID'),
'required' => TRUE,
+ 'where' => 'civicrm_custom_field.id',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'title' => ts('Custom Group'),
'description' => ts('FK to civicrm_custom_group.'),
'required' => TRUE,
+ 'where' => 'civicrm_custom_field.custom_group_id',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'description' => ts('Variable name/programmatic handle for this group.'),
'maxlength' => 64,
'size' => CRM_Utils_Type::BIG,
+ 'where' => 'civicrm_custom_field.name',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'required' => TRUE,
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_custom_field.label',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'required' => TRUE,
'maxlength' => 16,
'size' => CRM_Utils_Type::TWELVE,
+ 'where' => 'civicrm_custom_field.data_type',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'required' => TRUE,
'maxlength' => 32,
'size' => CRM_Utils_Type::MEDIUM,
+ 'where' => 'civicrm_custom_field.html_type',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'description' => ts('Use form_options.is_default for field_types which use options.'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_custom_field.default_value',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Custom Field Is Required?'),
'description' => ts('Is a value required for this property.'),
+ 'where' => 'civicrm_custom_field.is_required',
'default' => '0',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Allow Searching on Field?'),
'description' => ts('Is this property searchable.'),
+ 'where' => 'civicrm_custom_field.is_searchable',
'default' => '0',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Search as a Range'),
'description' => ts('Is this property range searchable.'),
+ 'where' => 'civicrm_custom_field.is_search_range',
'default' => '0',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'title' => ts('Order'),
'description' => ts('Controls field display order within an extended property group.'),
'required' => TRUE,
+ 'where' => 'civicrm_custom_field.weight',
'default' => '1',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'type' => CRM_Utils_Type::T_TEXT,
'title' => ts('Custom Field Pre Text'),
'description' => ts('Description and/or help text to display before this field.'),
+ 'where' => 'civicrm_custom_field.help_pre',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_TEXT,
'title' => ts('Custom Field Post Text'),
'description' => ts('Description and/or help text to display after this field.'),
+ 'where' => 'civicrm_custom_field.help_post',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'description' => ts('Optional format instructions for specific field types, like date types.'),
'maxlength' => 64,
'size' => CRM_Utils_Type::BIG,
+ 'where' => 'civicrm_custom_field.mask',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'description' => ts('Store collection of type-appropriate attributes, e.g. textarea needs rows/cols attributes'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_custom_field.attributes',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'description' => ts('Optional scripting attributes for field.'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_custom_field.javascript',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Custom Field Is Active?'),
'description' => ts('Is this property active?'),
+ 'where' => 'civicrm_custom_field.is_active',
'default' => '1',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Field is Viewable'),
'description' => ts('Is this property set by PHP Code? A code field is viewable but not editable'),
+ 'where' => 'civicrm_custom_field.is_view',
'default' => '0',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Field Options Per Line'),
'description' => ts('number of options per line for checkbox and radio'),
+ 'where' => 'civicrm_custom_field.options_per_line',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Field Length'),
'description' => ts('field length if alphanumeric'),
+ 'where' => 'civicrm_custom_field.text_length',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Field Start Date'),
'description' => ts('Date may be up to start_date_years years prior to the current date.'),
+ 'where' => 'civicrm_custom_field.start_date_years',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Field End Date'),
'description' => ts('Date may be up to end_date_years years after the current date.'),
+ 'where' => 'civicrm_custom_field.end_date_years',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'description' => ts('date format for custom date'),
'maxlength' => 64,
'size' => CRM_Utils_Type::BIG,
+ 'where' => 'civicrm_custom_field.date_format',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Field Time Format'),
'description' => ts('time format for custom date'),
+ 'where' => 'civicrm_custom_field.time_format',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Field Note Columns'),
'description' => ts(' Number of columns in Note Field '),
+ 'where' => 'civicrm_custom_field.note_columns',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Field Note Rows'),
'description' => ts(' Number of rows in Note Field '),
+ 'where' => 'civicrm_custom_field.note_rows',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'description' => ts('Name of the column that holds the values for this field.'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_custom_field.column_name',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Field Option Group'),
'description' => ts('For elements with options, the option group id that is used'),
+ 'where' => 'civicrm_custom_field.option_group_id',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'description' => ts('Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_custom_field.filter',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',
'bao' => 'CRM_Core_BAO_CustomField',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Field Display'),
'description' => ts('Should the multi-record custom field values be displayed in tab table listing'),
+ 'where' => 'civicrm_custom_field.in_selector',
'default' => '0',
'table_name' => 'civicrm_custom_field',
'entity' => 'CustomField',