public function Redirect404SensorPlugin::getAggregateQuery in Monitoring 8

Builds simple aggregate query over one db table.

Return value

\Drupal\Core\Database\Query\Select The select query object.

Overrides DatabaseAggregatorSensorPlugin::getAggregateQuery

File

src/Plugin/monitoring/SensorPlugin/Redirect404SensorPlugin.php, line 47

Class

Redirect404SensorPlugin

Monitors 404 error requests.

Namespace

Drupal\monitoring\Plugin\monitoring\SensorPlugin

Code

public function getAggregateQuery() {
  $query = parent::getAggregateQuery();
  $query
    ->addField('redirect_404', 'path');

  // The message is the requested 404 URL.
  $query
    ->condition('resolved', 0);
  $query
    ->orderBy('daily_count', 'DESC');
  $query
    ->range(0, 1);
  return $query;
}