#community-help

Sorting JSON Collection by Specific ID Order

TLDR GM asked how to sort JSON results by specific IDs. Jason suggested using pinned_hits parameter or sorting results client-side.

4mo

Join the chat

May 30, 2023 (4 months ago)

Photo of md5-9f364f57af6f71faaf6ea963342ef3f6

GM

07:11 PM

HI Team, i have JSON collection ,i am searching by ids like 2,59,8,9 and need result in same order as i mentioned in ids.that means what ever out put releated ID 2 should come first,then 59 ,then 8,then 9..how to achive

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

08:12 PM

You could use the pinned_hits parameter for this, but you will have to repeat the IDs in both pinned hits and also filter_by

08:13

Jason

08:13 PM

Alternatively, if you already know the order of the IDs when sending it in the filter_by parameter, you could then sort the results from Typesense on the client-side using the same sort oder

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 2786 threads (79% resolved)

Join Our Community Manage subscription

Similar Threads

Retrieving Multiple Documents by ID in Typesense

Bruno asked about retrieving multiple documents by ID in Typesense. Jason suggested using `filter_by: id:=` and gave advice on POST requests and order preservation. Bruno successfully implemented these solutions.

3mo

Implementing Result Pinning in Typesense Product

Sai questioned about implementing result pinning in Typesense for a product. Kishore Nallan provided several resources and explanations to assist, ultimately suggesting the use of 'sort_by' to promote groups of objects based on an attribute.

28mo

Issues Sorting Multiple Fields with Sort_by in Typesense Query

Rishabh was having trouble sorting two fields separately with a single query. Jason explained that a secondary sorting will only occur if the first sort results in matching values. They clarified the functionality of sorting in various search engines.

32mo