#community-help

Querying Documents with Specific Fields and Wildcards

TLDR Jacob asked how to query a subset of documents having specific fields. Kishore Nallan suggested using NULL as an identifier to exclude documents without the required field.

3mo

Join the chat

Jun 19, 2023 (3 months ago)

Photo of md5-c60456339dc3724ba99c3f7ca170d671

Jacob

06:01 AM

I want to search in a field that only a subset of documents have, and I want to exclude all documents that does not have that field. How do I design a query for that? I want to allow wildcard (*) as a valid query value.

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

06:09 AM

There's no way to automatically exclude documents that don't have a field. You will have to store an identifier like NULL which you can exclude in filter by clause.

Jacob

06:16 AM

Oh, ok. The problem for me is that it’s a dynamically named field. But thanks for the quick reply!

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

Querying Documents Using Wildcards and Array Lengths

Orion asks about querying documents with wildcards or array lengths. Jason requests clarification and examples from Orion to better understand the question.

17mo

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.

9mo

Filtering Based on Null or Specific Field Value in Typesense

Matheus asked how to filter documents on a null or specific field value. Jason suggested using a placeholder string to represent null values for filtering purposes.

18mo