Florian R.
09/05/2024, 1:02 PMuser_created
and user_updated
, but the relations fields is on one collection User
. I want to sort by user_created.name
field, but how i can do this ? In Api Reference, i do :
{
"sort_by": "$users(name:desc )"
}
But i want more that :
{
"sort_by": "$users(_eval(id:=user_created.id):name:desc)"
}
Any suggestions ?
🙂Harpreet Sangar
09/05/2024, 1:35 PM{
"sort_by": "$users(_eval(id:=user_created.id):desc, name:desc)"
}
Florian R.
09/05/2024, 1:50 PMFlorian R.
09/05/2024, 2:12 PM{
"sort_by": "$users(_eval(id:=user_created.id), name:desc)"
}
It's means in SQL
SELECT mc.user_created, mc.user_updated, uc.name
FROM MyCollection mc
JOIN userCreated uc ON uc.id === mc.user_created
ORDER BY uc.name DESC
Harpreet Sangar
09/05/2024, 2:27 PM