'title' => ts('Instant Messenger ID'),
'description' => ts('Unique IM ID'),
'required' => TRUE,
+ 'where' => 'civicrm_im.id',
'table_name' => 'civicrm_im',
'entity' => 'IM',
'bao' => 'CRM_Core_BAO_IM',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('IM Contact'),
'description' => ts('FK to Contact ID'),
+ 'where' => 'civicrm_im.contact_id',
'table_name' => 'civicrm_im',
'entity' => 'IM',
'bao' => 'CRM_Core_BAO_IM',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('IM Location Type'),
'description' => ts('Which Location does this email belong to.'),
+ 'where' => 'civicrm_im.location_type_id',
'table_name' => 'civicrm_im',
'entity' => 'IM',
'bao' => 'CRM_Core_BAO_IM',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('IM Provider'),
'description' => ts('Which IM Provider does this screen name belong to.'),
+ 'where' => 'civicrm_im.provider_id',
'table_name' => 'civicrm_im',
'entity' => 'IM',
'bao' => 'CRM_Core_BAO_IM',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Is IM Primary?'),
'description' => ts('Is this the primary IM for this contact and location.'),
+ 'where' => 'civicrm_im.is_primary',
'default' => '0',
'table_name' => 'civicrm_im',
'entity' => 'IM',
'type' => CRM_Utils_Type::T_BOOLEAN,
'title' => ts('Is IM Billing?'),
'description' => ts('Is this the billing?'),
+ 'where' => 'civicrm_im.is_billing',
'default' => '0',
'table_name' => 'civicrm_im',
'entity' => 'IM',