get all joined community sites under current site collection in search results/REST search/CSOM

Question

I've list of community sites in a site collection, and I have a publishing page on my site collection with a content editor WebPart on it. I've to show list of joined community sites on this webpart and I've a button "show more" at the bottom of the webpart, when i click on it I've to show a search result webpart which shows all joined community sites under current site collection. I'm trying use REST / CSOM on this content editor webpart. but i didn't find any way to do this. any ideas?

Answer 1

OK, I think I understand. There are a couple approaches you could take. Members of a Community Site are stored in the Members list. You can query the list with a KQL query like "ContentClass:STS_ListItem_880 {User.Name}" or "MemberOWSUSER:{User.Name}" this will return the Members list items from the sites. You could then trim the returned URLs to determine the associated sites. You might even be able to sort the return by the points you have on the site. That would be cool.

you could implement a result source of community sites or members to assist in narrowing your focus. It would add an interesting dimension to the query depending on what you are trying to accomplish.

You could add this query to a Search Web Part and apply a custom Display Template to render the Sites in a better presentation than the default item.

BTW, the default community sites search returns the sites you have access to, even if you are not a member because that is how search works in SharePoint. If you apply security to the sites it will prevent this from happening. The query is simply looking for the Community Site template.