Symfony Entity Manager -> getRepository question

[michaelt-94]

Hello,

Thank you for writing this bundle, I tried three different ones before yours and this is the only one I could make work. However, it seems to be a little too magical. When using EntityManagerInterface -> getRepository -.findBy() metohd. I am trying to the order my items in desc order on the 'create_at' field. Here is my call

$allNotes = $em->getRepository(Note::class)->findBy(['client_id' => $id], ['created_at' => 'desc']);

I noticed that when migrations are ran that the timestampable properties are not added directly to the Entity itself (no getters or setters == Magic!) So when using the getRepository metohds, I cannot use that property even when I add those to the entity. Have you had this issue?

Do you have any work arounds or suggestions?

Thank you.

[cristoforocervino]

Hi @michaelt-94,
thanks for choosing our bundle in the first place!

Don't worry, we don't like to be that magical and you can find some tips down here!

• Makes sure your entity implements Andante\TimestampableBundle\Timestampable\TimestampableInterface;
• Make sure your entity use Andante\TimestampableBundle\Timestampable\TimestampableTrait in order to actually add createdAt and updatedAt properties to your entities;
• Beware doctrine repositories uses DQL, so you need to use entity property name instead of database column name! I'm not sure if your database column client_id is mapped to a property clientId, but I can tell you for sure you should use createdAt to interact with our property inside you repository. Something like $allNotes = $em->getRepository(Note::class)->findBy(['clientId' => $id], ['createdAt' => 'desc']);

Hopes you can solve your problem with the instructions up above. Otherwise, please let us know what is your current bundle configuration and how your entity is configured and we will do our best to find what's wrong!