I have a question about showing data from multiple site collections in SharePoint online.
I want each customer to have it's own site. This should be a site collection because if I make it a normal site and I create a task list, the customer is able to see other customers when assigning a task.
What I want to do is the following. Every customer has a site collection with a question list in it. On the root site I want to show all questions for all customers. I've already done such a thing with a keywordquery in a farm solution.
To show data from multiple site collections in sharepoint online sandboxed solution I've tried:
- using a keywordquery
- using the search.asmx webservice
But unfortunately both can't be used in a sandboxed solution. What would be the easiest way to accomplish this?