ISSUE: SORT By on referenced field with left joins...
# community-help
a
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