#community-help

Displaying More Populated Documents First in Typesense Cloud

TLDR Rushil had a question on how to display the most populated documents first in Typesense cloud. Jason suggested creating a new field to set this function and further clarified related inquiries.

15mo

Join the chat

Sep 21, 2022 (15 months ago)

Photo of md5-23d3662ca8a778f4934a53bf33a66f97

Rushil

02:14 AM

👋 Hi everyone! I had a question for typesense cloud, what functions and syntax would i use to display the most populated documents first in any given filter?

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

02:16 AM

> most populated documents first in any given filter
Could you elaborate on this with an example? Didn’t quite understand this

Rushil

06:47 AM

So I have data that has more fields filled out than others, but on loading the documents the data with less fields filled out shows at the beginning. How can i sort it such that the data that is more populated shows first at any point.

Jason

03:16 PM

I’d recommend creating a new field called “filled_out_fields_count” and setting that when indexing the documents in Typesense, and then you can use that field in the sort_by search parameter

Rushil

06:48 PM

Yeah that makes sense

06:49

Rushil

06:49 PM

But there is no way without editing that I could do it? Is any feature like that in the pipeline

Jason

06:50 PM

No we don’t have this feature planned because this is the first time I’ve heard of a use-case like yours!

Rushil

07:32 PM

Yeah its fairly unique, will implement what you mentioned. In the schema would I have to label the data as sort:true as well?

Jason

07:42 PM

For numeric data types, sort: true is set by default, so you don’t have to explicitly set it

Typesense

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

Indexed 3011 threads (79% resolved)

Join Our Community

Similar Threads

Fetching Random Documents Using Random Integer

em1nos inquires about fetching random documents, to which Jason confirms using a random integer is the method. Suggestion for new "random" sort order feature in Typesense was advised to be directed towards Github.

18mo

Typesense Performance with Large Datasets & Custom Sort

krok inquires about Typesense's performance on large datasets and custom sorting. Kishore Nallan explains that Typesense is optimized for this scenario using pagination and text relevance.

10mo

Troubleshooting Typesense Document Import Error

Christopher had trouble importing 2.1M documents into Typesense due to memory errors. Jason clarified the system requirements, explaining the correlation between RAM and dataset size, and ways to tackle the issue. They both also discussed database-like query options.

10mo

Using Typesense to Search Specific Document IDs

Tshepo inquired about performing specific document ID searches in Typesense. Jason advised using the `filter_by=id:=[1,2,3,etc]` function or directly querying Typesense.

34mo

Sorting and Uploading Large Files in Typesense

Mridul asked about sorting by document id and uploading a large text file in Typesense. Jason rode in with suggestions on both queries.

2mo