How to build Query using Content Search Web part (CSWP) combining two sub-sites list items

-



How to build Query using Content Search Web part combining two sub-sites list items


Suppose we have two sub-sites here. One is called Corporate another is Community.



List id for corporate post: {AD553036-09E6-4647-A08F-1256A89F047A}
%7BAD553036%2D09E6%2D4647%2DA08F%2D1256A89F047A%7D
Here:
%7B = {
%2D = -
%7D = }
{D095E84A-1715-448D-8117-423F7DDA1490}
{F3A4C0D8-2042-40E9-8CB0-0A071978DAE6}

As for two list IDs We can create condition like:

((ListID:D095E84A-1715-448D-8117-423F7DDA1490) OR (ListID:F3A4C0D8-2042-40E9-8CB0-0A071978DAE6))

%7B7CAEA679%2D782C%2D4B6E%2DA83B%2DD963CAB158B4%7D
list id for community post: {7CAEA679-782C-4B6E-A83B-D963CAB158B4}

Column name: Publish Status

owstaxIdPublish_x0020_Status:
owstaxIdPublish%5Fx0020%5FStatus:  here %5F means "_" underscore

Final Query:
owstaxIdStatus:#bda2992f-be00-4fa0-8d0e-41c3a680eb3a ((ListID:7CAEA679-782C-4B6E-A83B-D963CAB158B4) OR (ListID:AD553036-09E6-4647-A08F-1256A89F047A))




owstaxIdStatus , here “owstaxId” is system specific and “Status” is the column/field created on the library as Managed Metadata
ID “#bda2992f-be00-4fa0-8d0e-41c3a680eb3a” for Managed Metadata value “Published” for Status column.


owstaxIdStatus:#bda2992f-be00-4fa0-8d0e-41c3a680eb3a         (Managed Metadata column is: Status and id from Term store management)


ListID:AD553036-09E6-4647-A08F-1256A89F047A
path:http://sharepoint/sites/intranet/corporate/ OR path:http://sharepoint/sites/intranet/community/  ContentTypeId:0x0110*



Comments

Post a Comment

Popular posts from this blog

Document library or list when add and delete multiple times in a page as webpart, it is adding version number or the number of times added to that page. How to remove this?

-
Image
Go to page edit, on which the library is added. From the menu above, click on " Edit Properties ":   Figure-1 : The webpart (What's New) showing the index/version number 2. I created it once and deleted that one from this page. And when I added the same webpart again, it's showing version number. Now from the Edit Properties page, open/click the link “ Open web part page in maintenance view ” Select the item/s from the list and delete those applicable. You will find duplicate items here: Done!!!
Read more

List does not exist. The page you selected contains a list that does not exist. It may have been deleted by another user.

-
Image
When we save webpart to a file or site gallery and then reuse that on other page, it throws error like the following: Solution : Go to that list/webpart, create a new view. Create the view using "Standard View" as below: Give a view name and select the style "Basic Table": It must be "Basic Table". Don’t worry it will be normal automatically when you add this webpart later. Then save the view. Modify the view using SharePoint Designer and save to file or save to site gallery as follows: Then import the webpart in the page where you wanted. Be careful about the security on this library. If needed review the permission for that list/library/webpart. Imported/uploaded webpart will be available on the Miscellaneous menu on the left as follows: All done!!!
Read more