Multi table search in zombo

[bhalonen]

Zombo used to support multi table search #70

How would you recommend going about doing something similar in the current version?

Thanks.

[eeeebbbbrrrr]

That's a thing that never got ported forward from that very old version.

I can take a look at adding it, or something similar, in my spare time. In all the years ZDB has been around I've never heard of anyone actually wanting to do this.

[bhalonen]

right now we have an acceptable solution of running ~20 seperate queries on an sql pool.

[skreborn]

@eeeebbbbrrrr Our use case is pretty simple; there are many kinds of entities we manage, all of them having very different properties with little overlap, but all of them need to be searchable from a central location.

Right now, all of the common properties are merged into one big table and managed automatically by triggers, but it's a fragile construct, I'm afraid. One trigger missed in the schema somewhere down the line, and suddenly we're not finding relevant results.

If you happen to have an alternative route in mind we could take, I'd be more than happy to try.

[eeeebbbbrrrr]

@skreborn I feel like your comment is talking about something different than what @bhalonen mentioned (issue #70 no longer being a thing).

Sounds like maybe you want to read up on cross index joins.

[BlakeB415]

This is definitely something I'm needing at the moment. Is there a way to directly do this with a raw ES query in the meantime?