I’m a new user of Manticore Search and I must say that I’m very impressed. I was using ElasticSearch before. Thank you for creating such great software.
My question is: what’s the best way to search multiple indexes?
I have three indexes:
The result that I’m looking for is similar to what a query with one or more JOINs would output in T-SQL when searching on fields in multiple tables but within the same query.
SELECT * FROM person LEFT JOIN phone ON phone.person_id = person.id WHERE person.full_name = 'John Doe' OR phones.phone_number = '0112223'
Do I have to run multi-queries here? My main point of communication with Manticore is through its HTTP API.