result example

  /** * {@inheritdoc} */
  public function execute() {
    return $this
      ->prepare()
      ->compile()
      ->addSort()
      ->finish()
      ->result();
  }

  /** * Prepares the basic query with proper metadata/tags and base fields. * * @return $this * Returns the called object. * * @throws \Drupal\Core\Entity\Query\QueryException * Thrown if the base table does not exist. */
  

  public function execute() {
    return $this
      ->prepare()
      ->addAggregate()
      ->compile()
      ->compileAggregate()
      ->addGroupBy()
      ->addSort()
      ->addSortAggregate()
      ->finish()
      ->result();
  }

  /** * {@inheritdoc} */
  public function prepare() {
    parent::prepare();
    // Throw away the id fields.     $this->sqlFields = [];
    return $this;
  }