function Notifications_Subscription_Table::query_select in Notifications 7

Get query for selection

File

./notifications.list.inc, line 616

Drupal Notifications Framework - Default class file

Class

Notifications_Subscription_Table

Loadable collection of subscriptions for tablesel ect

Code

function query_select() {

  // Query data with $conditions and filters
  $query = db_select('notifications_subscription', 's')
    ->extend('PagerDefault')
    ->extend('TableSort');
  foreach ($this->conditions as $field => $value) {
    $query
      ->condition('s.' . $field, $value);
  }
  $query
    ->fields('s', array(
    'sid',
  ))
    ->limit(50)
    ->orderByHeader($this->header);
  return $query;
}