none
Pulling data from multiple lists from a search

    Question

  • I have 2 lists of data. One is a calendar where we store rotating on-call engineer information. The other is a list of applications where we store lots of data about each app.  I am looking to create a page with a search box. The user will enter the name of the application and they will receive a page that shows both the current on-call engineer from the calendar, as well as certain columns from the other list pertaining to that app.  Is there a way to pull data from 2 lists based off of 1 search entered? 
    Friday, April 7, 2017 8:09 PM

All replies

  • Is the app data in any way associated with the list of engineers, e.g. engineer A is responsible for apps X, Y and Z, but engineer B is responsible for apps Y and W?

    If no, then regardless of the app data, the engineer info would be always be the same, depending on the current date. You could display it separately from search, as an independent web part.

    If yes, you could use a simple list with lookup columns pulling information from both lists, and the users could filter/search for the name and receive both info about the app and the engineer. It is OOTB solution and does not require any customization.

    If none of these applies to your situation, you could have a look at Content Query and Content Search Web Parts:

    https://support.office.com/en-us/article/When-to-use-the-Content-Query-Web-Part-or-the-Content-Search-Web-Part-in-SharePoint-346a0f48-38de-409b-8a58-3bdca1768929

    You can find a good guide on how to configure the search web part to return only specific results here: 

    https://support.office.com/en-us/article/Configure-a-Content-Search-Web-Part-in-SharePoint-0dc16de1-dbe4-462b-babb-bf8338c36c9a 


    Saturday, April 8, 2017 2:15 PM