Untitled

interaction.query = SELECT tint.customer_id as hosi_customer_id ,tint.interaction_date as hosi_interaction_date ,tint.interaction_id as hosi_interaction_id ,tint.account_id as hosi_account_id,tcust.bu_id as hosi_bu_id ,tint.category_id as hosi_category_id,tint.created_date as hosi_created_date ,tint.custom_created_date as hosi_custom_created_date, tint.custom_interaction_date as hosi_custom_interaction_date,tint.custom_updated_date as hosi_custom_updated_date ,tcust.party_nbr as hosi_customer_party_nbr ,tint.external_ref_id1 as hosi_external_ref_id1 ,tint.external_ref_id2 as hosi_external_ref_id2 ,tint.external_ref_id3 as hosi_external_ref_id3 ,tint.interaction_category_id as hosi_interaction_category_id ,tint.interaction_channel as hosi_interaction_channel ,tint.interaction_correlation_id as hosi_interaction_correlation_id ,tint.interaction_direction as hosi_interaction_direction ,tint.interaction_message as hosi_interaction_message ,tint.interaction_mode as hosi_interaction_mode ,tint.interaction_module_nbr as hosi_interaction_module_nbr ,tint.interaction_nbr as hosi_interaction_nbr ,tint.interaction_outcome as hosi_interaction_outcome ,'' as hosi_interaction_sentiment_score ,tint.interaction_status as hosi_interaction_status ,tint.interaction_subtype_id as hosi_interaction_subtype_id ,tint.interaction_type_id as hosi_interaction_type_id,tcust.op_id as hosi_op_id ,tint.parent_interaction_id as hosi_parent_interaction_id ,tint.subscriber_id as hosi_subscriber_id ,tint.updated_by as hosi_updated_by ,tint.updated_date as hosi_updated_date ,tint.user_field1 as hosi_user_field1 FROM tibtcare.tcare_interaction tint JOIN tibtcare.tcare_customer tcust ON tcust.customer_id=tint.customer_id WHERE tcust.op_id='HOB' AND tcust.bu_id='DEFAULT' limit 100