'title' => ts('Mapping Field ID'),
'description' => ts('Mapping Field ID'),
'required' => TRUE,
+ 'where' => 'civicrm_mapping_field.id',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'title' => ts('Mapping ID'),
'description' => ts('Mapping to which this field belongs'),
'required' => TRUE,
+ 'where' => 'civicrm_mapping_field.mapping_id',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'description' => ts('Mapping field key'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_mapping_field.name',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'description' => ts('Contact Type in mapping'),
'maxlength' => 64,
'size' => CRM_Utils_Type::BIG,
+ 'where' => 'civicrm_mapping_field.contact_type',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'title' => ts('Column Number'),
'description' => ts('Column number for mapping set'),
'required' => TRUE,
+ 'where' => 'civicrm_mapping_field.column_number',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Location type ID'),
'description' => ts('Location type of this mapping, if required'),
+ 'where' => 'civicrm_mapping_field.location_type_id',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Phone type ID'),
'description' => ts('Which type of phone does this number belongs.'),
+ 'where' => 'civicrm_mapping_field.phone_type_id',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('IM provider ID'),
'description' => ts('Which type of IM Provider does this name belong.'),
+ 'where' => 'civicrm_mapping_field.im_provider_id',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Website type ID'),
'description' => ts('Which type of website does this site belong'),
+ 'where' => 'civicrm_mapping_field.website_type_id',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Relationship type ID'),
'description' => ts('Relationship type, if required'),
+ 'where' => 'civicrm_mapping_field.relationship_type_id',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'title' => ts('Relationship Direction'),
'maxlength' => 6,
'size' => CRM_Utils_Type::SIX,
+ 'where' => 'civicrm_mapping_field.relationship_direction',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'description' => ts('Used to group mapping_field records into related sets (e.g. for criteria sets in search builder
mappings).
'),
+ 'where' => 'civicrm_mapping_field.grouping',
'default' => '1',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'description' => ts('SQL WHERE operator for search-builder mapping fields (search criteria).'),
'maxlength' => 16,
'size' => CRM_Utils_Type::TWELVE,
+ 'where' => 'civicrm_mapping_field.operator',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',
'description' => ts('SQL WHERE value for search-builder mapping fields.'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_mapping_field.value',
'table_name' => 'civicrm_mapping_field',
'entity' => 'MappingField',
'bao' => 'CRM_Core_DAO_MappingField',