Entity Query field condition for Webform submissions I'm trying to query webform submissions based on a field value. The field is called "ticket_for".
Somethings I tried and do not work:

    -&gt;condition('ticket_for',$adnummer)
    -&gt;condition('webform_submission_data:ticket_for',$adnummer,'CONTAINS')
...


What kind of condition should I be using in a query like this?

$query = \Drupal::entityQuery('webform_submission')
-&gt;condition('webform_id', 'ticket')
-&gt;condition('entity_id', $eventID)
-&gt;condition('webform_submission_data:ticket_for',$adnummer,'CONTAINS');
As imclean says webform_submission_data stores as EAV model. You can also do the following, If you need to have just one condition ticket_for == $adnummer.

$select = \Drupal::service('database')
-&gt;select('webform_submission_data', 'wsd')
-&gt;fields('wsd', array('sid'))
-&gt;orderBy('wsd.sid', 'DESC')
-&gt;condition('wsd.webform_id', 'your_webform_id', '=')
-&gt;condition('wsd.name', 'ticket_for', '=')
-&gt;condition('wsd.value', $adnummer, '=')
-&gt;execute();

$results = $select-&gt;fetchAll(\PDO::FETCH_COLUMN);
if ($results != null &amp;&amp; count($results) &gt;= 1) {
    $storage = \Drupal::entityTypeManager()-&gt;getStorage('webform_submission');
    $submissions = $storage-&gt;loadMultiple($results);    
}


Now just loop the $submissions. Done.