ResolvedSelf Hosted

[SOLVED] Best way to search multiple indexes?

Dec 27, 2023, 17:31

View on Discord

Votes

Replies

Participants

Unknown

Messages

ZachHandleyOriginal post

Moderator

Oct 30, 2023, 00:40

just curious, is there a better way to search multiple indexes at once rather than doing a listDocuments for each one? Any way to combine search queries to search all full text indices?

Summary

Solution: Unfortunately, it is not currently possible to search multiple indexes using the "OR" operation. One workaround is to create a single search attribute that includes all the data you want to search across and then create a full-text index on that attribute. This will allow you to search through multiple attributes at once. Another workaround suggested by a user is to use the "listDocuments" function to search each index separately, but there is no way to combine search queries to search all full-text indices simultaneously.

Drake

Admin

Oct 30, 2023, 03:00

Sounds like you want to do an OR?

ZachHandley

Moderator

Oct 30, 2023, 04:15

Sort of, I was trying to use search over multiple indices

ZachHandley

Moderator

Oct 30, 2023, 04:15

I have a data table in Vuetify that has a search parameter optionally, and when I search a collection I'd love to be able to search a list of attributes that are fulltext indexed rather than what seems to be like I need to search through each attribute?

Drake

Admin

Oct 30, 2023, 04:17

Which is like:

Search(attr1, keyword) OR
Search(attr2, keyword) OR
Search(attr3, keyword)

Since we don't support OR yet, this isn't possible.

One hack with search is you can create 1 search attribute with all the data you want to search across and then create a full text index on that attribute

ZachHandley

Moderator

Oct 30, 2023, 15:04

Ooooh that’s genius thank you for that ❤️

ZachHandley

Moderator

Oct 30, 2023, 15:05