Grouping and Ordering Results in Database Queries
TLDR Maximilian asked about grouping and ordering results by number of hits per group. Kishore Nallan clarified that faceting could be used, but could not order by counts.
Mar 24, 2022 (18 months ago)
Maximilian
11:45 AM
Kishore Nallan
11:51 AMMaximilian
11:54 AMFaceting would create two lists, one grouped by category and the other grouped by brand. Is it correct?
Kishore Nallan
01:03 PMMaximilian
02:13 PM
Typesense
Indexed 2764 threads (79% resolved)
Similar Threads
Understanding Facet Results in Typesense
Prabhu had difficulty understanding the count results of his facet results in Typesense. Kishore Nallan explained the behaviour and suggested creating a Github issue for a feature request to modify count behaviour.
1Sorting and Grouping Order Collections by ItemId and Price
Xing had trouble sorting and grouping order collections by item Id and lowest price. Ivan suggested using facet_by, while Kishore Nallan clarified that only desc order on highest price is possible and suggested a feature request.
Querying and Updating Facets in Typesense
Hafiz asked about sum/average of records, hourly grouping, and data formatting in Typesense. Kishore Nallan advised on using `facet_by`, grouping methods, and bulk update options. Hafiz was unable to get sum by group but was advised to store records pre-grouped.
2