Using a Content Search Web Part to show items from multiple subsites ,that have their status = "Pending" & their Assing-To = "the current login user"

Question

I am working on a site collection of type Team Site inside SharePoint server 2013. and i have the following :-

1. The site collection have 10 sub-sites.

2. all the 10 sub-sites were created using the same site template.

3. 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:-

1. 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)?

2. How I can filter the items to show only the items that have their Status = Pending and their Assign-To = ME (the login user)??

Answer 1

Apart form restricting the Path to current site collection, you need to specify STS_List_IssueTrackingto get items from Issue Tracking lists only. Moreover, you need to check the managed properties available for Status and Assigned To fields in the Search settings and then use them in the search query. Example:

Status:Pending AND AssignedTo:{User.Name}

Answer 2

First of all you put only path in your query so that you get any results. If you get results your search is running ok.

path:"http://YOURSITE"

After that you go to desire list/s and click List Settings, copy listID from url and decode it from 1aaaaaaa%2Daaaa... format to format with "-" 1aaaaaaa-aaaa...

http://meyerweb.com/eric/tools/dencoder/ - paste id and click decode

After that write in query ListID: contains not ListID= equal

path:"http://YOURSITE"
(IsDocument:"True" OR contentclass:"STS_ListItem")
( ListID:1aaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa )

For more lists put OR in query

path:"http://YOURSITE"
(IsDocument:"True" OR contentclass:"STS_ListItem")
( ListID:1aaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa )
OR
( ListID:2aaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa )
OR
( ListID:... )

If you want all lists from content class IssueTracking (https://social.technet.microsoft.com/Forums/sharepoint/en-US/9f87d5d7-08bf-442d-ad3f-91036d164954/content-class-identifier-stslist) and filter to show only items that have Status=Pending and AssignTo=CurrentUser then your query will look like this:

path:"http://YOURSITE"   
contentclass:"STS_ListItem_IssueTracking"
Status:Pending AND AssignedTo:{User.Name}

If Status:Pending don't return anything, try with StatusOWSCHCS:Pending or if you add custom column add that managed property.

EDIT

Look in Managed Properties and find that new column

http://YOURSITE/_layouts/15/listmanagedproperties.aspx?level=sitecol

Something like RiskIssueStatusOWSCHCS and add that in query

Answer 3

I would recommend creating a new result source using the content type for the selection of the content to be searched and check to make sure it is returning results from the lists you want. Only then move on to the filtering in the query.

To filter by properties of a column you will need to ensure that the column is mapped to a managed property within the search schema.

https://technet.microsoft.com/en-us/library/jj219630.aspx

I would suggest focusing on the Assigned to field first as you will note from the above that it is automatically assigned as a managed property.

Then when that is working to filter content properly move on to the Risk/Issue status column which will need to be mapped in the schema before it can be used in the query. Assistance from MS below.

https://technet.microsoft.com/en-us/library/jj219667.aspx