'title' => ts('Option Value ID'),
'description' => ts('Option ID'),
'required' => TRUE,
+ 'where' => 'civicrm_option_value.id',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'bao' => 'CRM_Core_BAO_OptionValue',
'title' => ts('Option Group ID'),
'description' => ts('Group which this option belongs to.'),
'required' => TRUE,
+ 'where' => 'civicrm_option_value.option_group_id',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'bao' => 'CRM_Core_BAO_OptionValue',
'required' => TRUE,
'maxlength' => 512,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_option_value.label',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'bao' => 'CRM_Core_BAO_OptionValue',
'required' => TRUE,
'maxlength' => 512,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_option_value.value',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'bao' => 'CRM_Core_BAO_OptionValue',
'size' => CRM_Utils_Type::HUGE,
'import' => TRUE,
'where' => 'civicrm_option_value.name',
- 'headerPattern' => '',
- 'dataPattern' => '',
'export' => TRUE,
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'description' => ts('Use to sort and/or set display properties for sub-set(s) of options within an option group. EXAMPLE: Use for college_interest field, to differentiate partners from non-partners.'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_option_value.grouping',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'bao' => 'CRM_Core_BAO_OptionValue',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Filter'),
'description' => ts('Bitwise logic can be used to create subsets of options within an option_group for different uses.'),
+ 'where' => 'civicrm_option_value.filter',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'bao' => 'CRM_Core_BAO_OptionValue',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Option is Default?'),
'description' => ts('Is this the default option for the group?'),
+ 'where' => 'civicrm_option_value.is_default',
'default' => '0',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'title' => ts('Order'),
'description' => ts('Controls display sort order.'),
'required' => TRUE,
+ 'where' => 'civicrm_option_value.weight',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'bao' => 'CRM_Core_BAO_OptionValue',
'description' => ts('Optional description.'),
'rows' => 8,
'cols' => 60,
+ 'where' => 'civicrm_option_value.description',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'bao' => 'CRM_Core_BAO_OptionValue',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Option is Header?'),
'description' => ts('Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?'),
+ 'where' => 'civicrm_option_value.is_optgroup',
'default' => '0',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Option Is Reserved?'),
'description' => ts('Is this a predefined system object?'),
+ 'where' => 'civicrm_option_value.is_reserved',
'default' => '0',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Option Is Active'),
'description' => ts('Is this option active?'),
+ 'where' => 'civicrm_option_value.is_active',
'default' => '1',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Option Component'),
'description' => ts('Component that this option value belongs/caters to.'),
+ 'where' => 'civicrm_option_value.component_id',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'bao' => 'CRM_Core_BAO_OptionValue',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Option Domain'),
'description' => ts('Which Domain is this option value for'),
+ 'where' => 'civicrm_option_value.domain_id',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'bao' => 'CRM_Core_BAO_OptionValue',
'name' => 'visibility_id',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Option Visibility'),
+ 'where' => 'civicrm_option_value.visibility_id',
'default' => 'NULL',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'description' => ts('crm-i icon class'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_option_value.icon',
'default' => 'NULL',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',
'description' => ts('Hex color value e.g. #ffffff'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_option_value.color',
'default' => 'NULL',
'table_name' => 'civicrm_option_value',
'entity' => 'OptionValue',