BatchList - sort by Platform or Project examines `id`, not `name`

[IanMayo]

In the BatchList page the user can choose to sort by Platform and Project. But the items aren't displayed in alphabetical order.

I'm pretty sure they are being sorted by id, not name.

[TahaKhanAbdalli]

Hi @IanMayo, I have just gone through the issue and came to know that the soul is not sorting the foreign key.

Meaning, in our current case, we are getting data from other tables on the basis of Id and in reference to the Id, we show data on the batch list. So when we sort the project or platform or any other column which is a foreign key in current table, it sorts the Id first, then gets the data from other tables (referenced table) according to that sorted Id.

[IanMayo]

Yes, that matches my understanding. When asking for data to be sorted by User the users are expecting to be sorted into Andrew, Brian, Christine, Delia, etc. But, actually it's sorted by 1, 3, 5, 12 - which could get rendered as Brian, Delia, Christine, Andrew.

The only way I can think of solving this is to introduce more RichItem style SQL VIEWs - which includes the FK names - so as well as user we have userName - and we allow the users to sort by these rich values.

[TahaKhanAbdalli]

Yes, @IanMayo we can do that.

[IanMayo]

Ok, @TahaKhanAbdalli - but let's defer this for a future phase please.

This and #997 both require a related solution: the introduction of rich tables. But, I don't have customer endorsement for working on it yet.

[IanMayo]

We should research this further - I'd be surprised if React-Admin didn't have a way of supporting it. Hmm, or maybe it should be delegated to soul-cli.