TYPO3 Core

When building a query inside a repository method using $this->createQuery() and defining an 'IN' constraint by chaining the methods $query->matching() and $query->in() the execution of the query yields an SQL error.

#1472074379: Unknown column 'foo' in 'where clause'

Code example:

public function findUsingOptions() {
$options = [
'foo',
'bar',
'foobar',
];

$query = $this->createQuery();
    $query->matching($query->in('my_column', $options));
    return $query->execute();
}