Easyadminbundle: [3.0] AssociationField in the index-page looks sortable, but clickin it renders the index empty

[parijke]

Describe the bug
Explain what you wanted to do and the wrong result you got.

To Reproduce
Create a list with an AssociationField. It renders sortable/clickable. Clicking on it displays an empty index

(OPTIONAL) Additional context
If they are useful, include logs, code samples, screenshots, etc.

After clicking the Assigned To

[seb-jean]

I also have the problem.

[lukasluecke]

We would probably need a way to define the "sort fields" (Doctrine / DB level) on the target entity, and then use those to order the results.

The quick fix would be to just mark them as not sortable until there is a proper solution available. You can already do that manually for now with ->setSortable(false) on the field.

[seb-jean]

@lukasluecke It is an excellent idea :)

[JSmythSSG]

I manually altered the search url with dot notation and it works.
sort%5BparentCompany%5D=DESC
to
sort%5BparentCompany.name%5D=DESC

So if its easier to somehow just alter how it generates the url

[JSmythSSG]

I did some digging through the code and managed to get it to work by adding a sort property for the association field. It checks if that property is valid for that entity or throws an exception.

If a sort property exists then the twig template will append the sortProperty to the field property name for the url eg sort=contact.name which seems to work fine with my testing.

[makerlabs]

Until the issue is fixed the best workaround I found is to add the related entity name and their property as properyName and set is as sortable for example:
yield TextField::new('unit.name', 'unit')->setSortable(true)->onlyOnIndex();

[quentint]

Apparently fixed by 91ef0ebb192aa9300988d3c8bf0eb80cc14ed45c.

[parijke]

Indeed, fixed

[krewetka]

Yes but it broke other user cases. Check the issue https://github.com/EasyCorp/EasyAdminBundle/issues/3879

I think @JSmythSSG general idea of specifying sortProperty was a nice one :)