Remove a join from an integration

Parameters

$setup_id: The setup_id of the integration to delete the join from

$base_table: The name of the base table involved the join

$base_field: The field from the base table involved in the join

$left_table: The name of the other table involved in the join

$left_field: The name of the field from the other table involved in the join

Related topics

File

tripal_views/api/tripal_views.api.inc, line 925

API functions for Tripal Views Integration

Code

function tripal_views_remove_join_from_integration($setup_id, $base_table, $base_field, $left_table, $left_field) {
  db_query(
  "DELETE FROM {tripal_views_join} WHERE setup_id=%d AND base_table='%s' AND base_field='%s' AND left_table='%s' AND left_field='%s'", 
  $setup_id, 
  $base_table, 
  $base_field, 
  $left_table, 
  $left_field
  );
}