You need to sign in to do that
Don't have an account?
Mark Crooksy
How can I order the results of a FIND query?
This query returns results in record id order:
FIND {word*} IN Name FIELDS RETURNING contact (contact.Id, contact.Salutation, contact.FirstName, contact.LastName, contact.Title, contact.Email);
What I would like to achieve is something like:
FIND {word*} IN Name FIELDS RETURNING contact (contact.Id, contact.Salutation, contact.FirstName, contact.LastName, contact.Title, contact.Email) ORDER BY LastName ASC
Would anyone know if this is possible?
Thanks,
Mark
FIND {word*} IN Name FIELDS RETURNING contact (contact.Id, contact.Salutation, contact.FirstName, contact.LastName, contact.Title, contact.Email);
What I would like to achieve is something like:
FIND {word*} IN Name FIELDS RETURNING contact (contact.Id, contact.Salutation, contact.FirstName, contact.LastName, contact.Title, contact.Email) ORDER BY LastName ASC
Would anyone know if this is possible?
Thanks,
Mark
FIND {word*} IN Name FIELDS RETURNING contact (contact.Id, contact.Salutation, contact.FirstName, contact.LastName, contact.Title, contact.Email ORDER BY LastName ASC )
reference:
http://www.salesforce.com/us/developer/docs/officetoolkit/Content/sforce_api_calls_sosl_select_order_by_with_limit.htm
All Answers
FIND {word*} IN Name FIELDS RETURNING contact (contact.Id, contact.Salutation, contact.FirstName, contact.LastName, contact.Title, contact.Email ORDER BY LastName ASC )
reference:
http://www.salesforce.com/us/developer/docs/officetoolkit/Content/sforce_api_calls_sosl_select_order_by_with_limit.htm