condition('greetings', 'merhaba', '=', 'tr'); * ->condition('greetings.value', 'siema', '=', 'pl'); * ->execute(); * $entity_ids = $query->execute(); * @endcode * * @param $field * Name of the field being queried. It must contain a field name, * optionally followed by a column name. The column can be "entity" for * reference fields and that can be followed similarly by a field name * and so on. Some examples: * - nid * - tags.value * - tags * - uid.entity.name * "tags" "is the same as "tags.value" as value is the default column. * If two or more conditions have the same field names they apply to the * same delta within that field. * @param $value * The value for $field. In most cases, this is a scalar and it's treated as * case-insensitive. For more complex operators, it is an array. The meaning * of each element in the array is dependent on $operator. * @param $operator * Possible values: * - '=', '<>', '>', '>=', '<', '<=', 'STARTS_WITH', 'CONTAINS', * 'ENDS_WITH': These operators expect $value to be a literal of the * same type as the column. * - 'IN', 'NOT IN': These operators expect $value to be an array of * literals of the same type as the column. * - 'BETWEEN': This operator expects $value to be an array of two literals * of the same type as the column. * @param $langcode * Language code (optional). If omitted, any translation satisfies the * condition. However, if two or more conditions omit the langcode within * one condition group then they are presumed to apply to the same * translation. If within one condition group one condition has a langcode * and another does not they are not presumed to apply to the same * translation. * * @return \Drupal\Core\Entity\Query\QueryInterface * @see \Drupal\Core\Entity\Query\andConditionGroup * @see \Drupal\Core\Entity\Query\orConditionGroup */ public function condition($field, $value = NULL, $operator = NULL, $langcode = NULL); /** * Queries for a non-empty value on a field. * * @param $field * Name of a field. * @param $langcode * Language code (optional). * @return \Drupal\Core\Entity\Query\QueryInterface */ public function exists($field, $langcode = NULL); /** * Queries for an empty field. * * @param $field. * Name of a field. * @param $langcode * Language code (optional). * @return \Drupal\Core\Entity\Query\QueryInterface */ public function notExists($field, $langcode = NULL); /** * Enables a pager for the query. * * @param $limit * An integer specifying the number of elements per page. If passed a false * value (FALSE, 0, NULL), the pager is disabled. * @param $element * An optional integer to distinguish between multiple pagers on one page. * If not provided, one is automatically calculated. * * @return \Drupal\Core\Entity\Query\QueryInterface * The called object. */ public function pager($limit = 10, $element = NULL); /** * @param null $start * @param null $length * @return \Drupal\Core\Entity\Query\QueryInterface * The called object. */ public function range($start = NULL, $length = NULL); /** * @param $field * Name of a field. * @param string $direction * @param $langcode * Language code (optional). * @return \Drupal\Core\Entity\Query\QueryInterface * The called object. */ public function sort($field, $direction = 'ASC', $langcode = NULL); /** * Makes this a count query. * * For count queries, execute() returns the number entities found. * * @return \Drupal\Core\Entity\Query\QueryInterface * The called object. */ public function count(); /** * Enables sortable tables for this query. * * @param $headers * An array of headers of the same structure as described in * template_preprocess_table(). Use a 'specifier' in place of a 'field' to * specify what to sort on. This can be an entity or a field as described * in condition(). * * @return \Drupal\Core\Entity\Query\QueryInterface * The called object. */ public function tableSort(&$headers); /** * @return \Drupal\Core\Entity\Query\QueryInterface * The called object. */ public function accessCheck($access_check = TRUE); /** * Queries the current or every revision. * * Note that this only affects field conditions. Property conditions always * apply to the current revision. * @TODO: Once revision tables have been cleaned up, revisit this. * * @param $age * - EntityStorageInterface::FIELD_LOAD_CURRENT (default): Query * the most recent revisions only, * - EntityStorageInterface::FIELD_LOAD_REVISION: Query all * revisions. * * @return \Drupal\Core\Entity\Query\QueryInterface * The called object. */ public function age($age = EntityStorageInterface::FIELD_LOAD_CURRENT); /** * Execute the query. * * @return int|array * Returns an integer for count queries or an array of ids. The values of * the array are always entity ids. The keys will be revision ids if the * entity supports revision and entity ids if not. */ public function execute(); /** * Creates a new group of conditions ANDed together. * * For example, consider a drawing entity type with a 'figures' multi-value * field containing 'shape' and 'color' columns. To find all drawings * containing both a red triangle and a blue circle: * @code * $query = \Drupal::entityQuery('drawing'); * $group = $query->andConditionGroup() * ->condition('figures.color', 'red') * ->condition('figures.shape', 'triangle'); * $query->condition($group); * $group = $query->andConditionGroup() * ->condition('figures.color', 'blue') * ->condition('figures.shape', 'circle'); * $query->condition($group); * $entity_ids = $query->execute(); * @endcode * * @return \Drupal\Core\Entity\Query\ConditionInterface */ public function andConditionGroup(); /** * Creates a new group of conditions ORed together. * * For example, consider a map entity with an 'attributes' field * containing 'building_type' and 'color' columns. To find all green and * red bikesheds: * @code * $query = \Drupal::entityQuery('map'); * $group = $query->orConditionGroup() * ->condition('attributes.color', 'red') * ->condition('attributes.color', 'green'); * $entity_ids = $query * ->condition('attributes.building_type', 'bikeshed') * ->condition($group) * ->execute(); * @endcode * Note that this particular example can be simplified: * @code * $entity_ids = $query * ->condition('attributes.color', array('red', 'green')) * ->condition('attributes.building_type', 'bikeshed') * ->execute(); * @endcode * * @return \Drupal\Core\Entity\Query\ConditionInterface */ public function orConditionGroup(); }