I am working on a site collection of type Team Site inside SharePoint server 2013. and i have the following :-
The site collection have 10 sub-sites.
all the 10 sub-sites were created using the same site template.
and each subsite have 2 lists (2 issue tracking lists).
Now I want inside the site collection’s home page to show a general list that display the following info:-
All the items from all the sub sites’ lists that have "Pending" status & are "Assign-To" the login user.
Now I read about the available options insides SharePoint and I settled on using the content search web part. So i did the following; from the site collection home page>>I edit the page>> I add a content search web part, and I define the following ( Mainly to retrieve only items + under the site collection URL + under the specified list id. but I did not get any result as follow:-
Now I have these questions:-
How I can force the above query to show the items from multiple lists IDs since i will have 20 lists (10 subsites X 2 lists)?
How I can filter the items to show only the items that have their Status = Pending and their
Assign-To = ME(the login user)??