[FIXED] Easy Admin 3 Sort by date returns: create_date has no field or association named create_date

Issue

I'm trying to sort a field either by asc or desc date.

When i add the date field to my backend like so

DateTimeField::new('create_date', 'Create Date')->setSortable(true),

It works and it shows, but when i try to sort it i get the following error

[Semantical Error] line 0, col 62 near 'create_date ': Error: Class App\\Entity\\MyEntitiy has no field or association named create_date File:/home/wwwroot/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php Line: 63

Does anyone know why or how this happens ?

Thank you

EDIT: here is the field in MyEntity

   /**
     * @var \DateTime|null
     *
     * @ORM\Column(name="create_date", type="datetime", nullable=true)
     */
    private $createDate;


 /**
 * Returns the CreateDate
 *
 * @return \DateTime|null
 */
public function getCreateDate(): ?\DateTime
{
    return $this->createDate;
}


/**
 * Sets the CreateDate
 *
 * @param \DateTime|null $createDate
 * @return void
 */
public function setCreateDate(?\DateTime $createDate)
{
    $this->createDate = $createDate;
}

Solution

You are not respecting the proper spelling for your property.

In your entity, the field is called createDate so you should use the same name when configuring your crud.

In your case :

DateTimeField::new('createDate', 'Create Date')->setSortable(true),

Answered By - Dylan Kas