function hook_salesforce_query_alter in Salesforce Suite 7.3

Alter a SOQL select query before it is executed. For example, filter target SObjects by a date value, or add an additional field to the query.

Parameters

SalesforceSelectQuery $query: The query object to alter.

See also

includes/salesforce.select_query.inc

Related topics

2 invocations of hook_salesforce_query_alter()

Salesforce::query in includes/salesforce.inc

Use SOQL to get objects based on query string.

Salesforce::queryAll in includes/salesforce.inc

Same as ::query() but also returns deleted or archived records.

File

./salesforce.api.php, line 205

These are the hooks that are invoked by the Salesforce core.

Code

function hook_salesforce_query_alter(SalesforceSelectQuery &$query) {
  if ($query->objectType == 'Contact') {
    $query->fields[] = 'Drupal_Field__c';
    $query
      ->addCondition('Email', "''", '!=');
  }
}