drupal-8-entity-query-regex.php

<?php

// assumes fieldName is a text field with 1 value
function FilterNodesByRegex($nids, $fieldName, $regex) {
  $nodes = \Drupal::entityTypeManager()->getStorage('node')->loadMultiple($nids);
  return array_filter($nodes, function($node) use ($regex, $fieldName) {
    return preg_match(
      $regex,
      $node->get($fieldName)->getString()
    );
  });
}


// example usage

// finds nids of type page with a field_my_rank value over 5
$nids = \Drupal::entityQuery('node')
  ->condition('type', 'page')
  ->condition('field_my_rank', 5, '>')
  ->sort('nid', ASC)
  ->execute();


// filters node list by field_my_text_input
$filteredResults = FilterNodesByRegex(
  $nids,
  'field_my_text_input',
  '/^have a \w+ day/i'
);

// matches nodes where field_my_text_input is:
// have a nice day 
// Have a great day
// have a pizza day

// does not match on:
// have a good time, it's a nice day
// clap your hands if you have a good day


?>

references:

• https://drupal.stackexchange.com/questions/213322/how-do-i-do-a-regex-query-in-reverse-in-entity-query
• https://www.drupaleasy.com/blogs/ultimike/2020/07/entityquery-examples-everybody
• https://api.drupal.org/api/drupal/core%21lib%21Drupal%21Core%21Config%21Entity%21Query%21Condition.php/function/Condition%3A%3Amatch/8.2.x