ISSUE: SORT By on referenced field with left joins
Hello everyone,
i am encountering one issue related to "SORT By on referenced field with left joins".
suppose i have users table and it has one to many relations with cars,
but it is not necessary that cars records exists thats why i am using left joins to get records of users like this in filter by: '(id:* || $cars(id:* && $car_details(id:*)))'
this is working fine .
but when i am applying sort by "'$cars(created_at:desc)'" it says "{'results': [{'code': 400, 'error': 'No references found to sort by on cars.created_at.'}]}"
this error is because some users doesnt have records in cars.
same issue was posted here
https://github.com/typesense/typesense/issues/2082
do you have any solution:
my version: 27.1