We have a page on a public website where we're surfacing a list of Staff which is stored in a "Catalog". The staff catalog has a lookup column pointing at a Department catalog. The Lookup is joining on a Department "ID" value and not the actual Department name itself.
We have a form and search web part on a page and are returning Staff that match against First Name, Last Name, Phone Number and Job Title using the Search API. We also need to be able to return matches for Department but this is not proving possible as the search index does not seem to contain the value from the Lookup list, only the ID value.
So my question is does anyone know how to use SharePoint 2013 search to return items from one list based on the query keyword appearing in the associated lookup item? Or am I going to have to first query the lookup list and get matching IDs and then build those IDs into a second query against the original list? I hope not...