if I use
$TR = $entityManager->getRepository(Transaction::class);
$cb = $TR->createQueryBuilder('t')
->select('DATE_FORMAT(t.time, "%d. %m. %y") AS date')
->distinct()
->getQuery();
The result query looks like “SELECT DISTINCT DATE_FORMAT(t.time, “%d. %m. %y”) AS date FROM Transaction t” and does not run, since the table name for entity Transaction is transactions.
I did declare
#[ORM\Entity]
#[ORM\Table(name: 'transactions')]
class Transaction
{...
in the class and also
$TR = $entityManager->getRepository(Transaction::class);
$cb = $TR->findAll();
var_dump($cb);
works like expected.
Any idea what I’m missing? Thanks a lot in advance for any hint!
Cheers