+ Start a Discussion

How to sort the results based on exact match from a SOSL query. In this example, I should see both the robert records on the top and the SOSL's fuzzy results in the bottom. What is the default order of SOSL results?

November 6, 2018
·
Answer
·
Like
0
·
Follow
2

Shravan Kumar 71
Hi Sumedha,

This post should clarify your doubt : https://salesforce.stackexchange.com/questions/154935/what-is-the-default-sort-order-for-records-in-sosl

Thanks,
Shravan

November 6, 2018
·
Like
0
·
Dislike
0

Raj Vakati
Try like below

FIND {raj} IN ALL FIELDS RETURNING Contact( FirstName,LastName Order By LastName )

November 7, 2018
·
Like
0
·
Dislike
0

sumedha p
Raj, I need the sorting to be done in a best match way not by first name or last name

November 7, 2018
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

How to sort the results based on exact match from a SOSL query. In this example, I should see both the robert records on the top and the SOSL's fuzzy results in the bottom. What is the default order of SOSL results?

You need to sign in to do that.