#community-help

Querying Nested Fields in Array Using Filters

TLDR Todd asked about using wildcards for array style searches in a nested field. Jason responded that using filter_by: topLevelField.nestedField:=5 should work. Todd confirmed that the solution was effective.

2mo

Join the chat

Jul 03, 2023 (2 months ago)

Photo of md5-cccf0b87668408fef09dd77e1948fced

Todd

08:22 PM

Hey all, the nested field stuff is looking great! However, I’m struggling to use them in filter conditions when nested in arrays. I was wondering if there was support for wildcards in array style searches, similar to a “some” check in SQL

For example, if I have this schema:

const schema: CollectionFieldSchema[] = [
  {
    name: 'topLevelField',
    type: 'object[]',
    facet: true,
  },
  {
    facet: true,
    name: 'topLevelField.nestedField',
    type: 'int32',
  },
];

And I have an entry with this shape:

{ topLevelField: [{ nestedField: 3 }, { nestedField: 5}]}

How can I filter that 5 is in the nestedField list?

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

08:25 PM

> I was wondering if there was support for wildcards in array style searches, similar to a “some” check in SQL
Typesense doesn’t support wild-cards in filter values

> How can I filter that 5 is in the nestedField list?
filter_by: topLevelField.nestedField:=5

should work…

08:25

Jason

08:25 PM

If that doesn’t work, could you replicate the issue using this snippet and some sample data?

Todd

08:26 PM

Jason - Thanks as always for the quick turnaround, and if I hit any issues trying that I’ll follow the template. Thank you sir!

08:41

Todd

08:41 PM

Jason - That syntax worked perfectly. Thank you!

Typesense

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

Indexed 2764 threads (79% resolved)

Join Our Community Manage subscription

Similar Threads

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.

8mo

Cold Start Problem with Dynamic Collections

Adrian reported cold start issues with dynamic collections. Jason suggested using wildcard `*` for query_by parameters, upgrading to `0.25.0.rc34`, and clarified conventions. Adrian's issues were resolved but they reported a limitation that will potentially be addressed.

4mo

Updating Collections Strategy and Faceting New Field

Nithin asked about strategies for updating collections and faceting new fields. Kishore Nallan suggested creating another collection, indexing in the background and using aliases to switch live traffic over, and shared details about the upcoming release.

29mo