Understanding Search Parameters and Functions in a Database
TLDR Mubashirullah needed help with formulating search queries. Kishore Nallan explained how to use filter_by, query_by, and facet_query. The thread ended with corrections to a search syntax error.
2
1
1
1Dec 21, 2021 (21 months ago)
Mubashirullah
10:11 AMI'm confused as to why I can't enter numbers in the query_by search parameter. If I want all results between 2 dates, am I suppose to add * in the q and all string fields in the query_by. In filter_by I include a range category :[timestamp_checkin timestamp_checkout]
I have checkIn and checkOut as separate fields. How do I formulate my search query? Thanks
Kishore Nallan
10:17 AM11Mubashirullah
10:25 AMKishore Nallan
10:25 AMq=* query_by does not matter.Kishore Nallan
10:26 AMMubashirullah
10:30 AMI'm a bit lost as to why facet_query exits. I have a field that filtery_by can filter for me.
Kishore Nallan
10:31 AMKishore Nallan
10:33 AM1Mubashirullah
11:27 AMKishore Nallan
11:28 AMMubashirullah
11:44 AMKishore Nallan
11:45 AM1Dec 22, 2021 (21 months ago)
Mubashirullah
08:02 AM...checkIn:>={} && checkOut:=<{}'.format(_dateConvertion('2021-12-19'), _dateConvertion('2021-12-20'))I don't get anyresults. When I change the checkout date to 2021-12-21 then I see the results with checkout date 2021-12-20.
Kishore Nallan
08:02 AM_dateConvertion do?Mubashirullah
08:05 AMMubashirullah
08:05 AMKishore Nallan
08:06 AMcheckout: <= {}Kishore Nallan
08:06 AM=<Mubashirullah
08:07 AM1
Typesense
Indexed 2764 threads (79% resolved)
Similar Threads
Fixing Multiple Document Retrieval in Typesense
Phil needed an efficient way to retrieve multiple documents by id. Kishore Nallan proposed a solution available in a pre-release build. After some bug fixing regarding id matching by Jason and Kishore Nallan, Phil successfully tested the solution.
4Understanding Facet Query and Filter By on Typesense
Ricardo needed clarification on using facet_query. Kishore Nallan explained its use alongside `filter_by`, helping Ricardo understand the concepts. The discussion also touched upon how facet_query works with sets of fields and the difference between facet_query and filter_by.
Moving from Algolia to Typesense: Questions and Answers
Juan sought advice from Kishore Nallan about moving from Algolia to Typesense, handling MultiSearch, setting parameters, checking imported documents, and a specific syntax query.
1Fuzzy Search Restrictions and num_typos Extension Request
Ashwin seeks to limit the fields covered by fuzzy search and wants specification of typo tolerance per field. Kishore Nallan suggests num_typos syntax to control the behavior, with Ashwin agreeing and planning to raise a related issue on Github. Jason advises on comparing integer time stamps for InstantSearch usage.
2Querying with Typesense-Js and Handling Null Values
michtio was querying using typesense-js and receiving fewer results than expected. Kishore Nallan suggested using different query parameters. Further discussion led to the handling of 'null' values and filtering syntax in the search queries. The thread ended with Jason offering migration support from Algolia to Typesense.
4