#community-help

Filtering by Unix Timestamps in Typesense

TLDR Nathan asked if it's possible to filter using current time in Typesense. Jason confirmed filtering requires generating and passing current unix timestamp from the client.

6mo

Join the chat

Jun 09, 2023 (6 months ago)

Photo of md5-aa846ac80f1164f0d27b340467fd28e2

Nathan

08:29 PM

I'm assuming the answer is "no," based on https://typesense.org/docs/guide/tips-for-searching-common-types-of-data.html#dates-times, but I'll ask anyways. Some of my fields are unixTimestamps, and I'd love to have a preset (or normal search) with filter_by=startTimestamp:>now. Is that possible, or do I always need to pass in an actual unix timestamp to compare startTimestamp with?

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

08:30 PM

The latter - you would have to generate the current unix timestamp in your client and then pass that as a numeric value to Typesense in the query

Typesense

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

Indexed 3015 threads (79% resolved)

Join Our Community

Similar Threads

Troubleshooting Typesense Filter_by Parameter Issue

Sagar had trouble with the filter_by parameter in Typesense. Kishore Nallan identified issue related to indexing, which resolved part of the issue. Guidance was given for handling null values.

4mo

Complex Query System and Collections Schema for Typesense

Orion asks about the grammar for 'filter_by' search parameters and where to find a collections schema. Jason provides the needed documentation and encourages Orion to share back.

5mo

Usage and Modification of Dynamic Routes in Typesense Documents

Ethan needed a way to perform exact queries through two fields in Typesense documents. Kishore Nallan demonstrated its possibility using the "filter_by". An issue was resolved via recommending that fields in 'query by' should be a string type.

11mo