Can AI Search results join multiple indexes? For tables that are related, but not extended?

[Jordan Blake]

We are interested in moving to AI Search and replace a customer-facing search engine, but there seems to be limitations I hope I can solve for.

Example: we use ServiceNow Community, and the Questions and Answers of a single post are separate tables. To provide a good search experience we need to index them both, but surface the data together and not in separate tabs since the users expectation when searching is they are together. 

There are other tabs that work this way which we have to surface in the search, and I'm struggling to find some feature of AI Search that allows for this type of configuration.

Thanks!

[Gerard Dwan]

While AI Search can do some interesting things with attachments (combining them with their parents), it can't perform the same operation from two different tables. 

If I understand which tables you're referring to, you could on your Search Source configure it so that only questions without answers are included. The answers table contains the question, so you can render the card to make it so the 'title' is the question, and the 'text' contains the answer (EVAM). You can also set one or both of the tabs to active=false in your Search Application to remove confusion and offer a facet for 'community content' that would be a custom field on that table. 

There are a few steps involved to get this experience just right, but it should be able to be handled through configuration.