1

Scenario :

I am using several sub-sites,each having its own task list used for managing a project. I want to have a centralized dashboard at the root of the collection,to demonstrate info on all the sub-sites project.

In short,i want to have an overview of the projects found in sub-sites in the root collection site. Let's say i want to have a project summary web-part that read the task list found in the sub-sites. Any other idea is also welcome.

Can i add a task list that read task from the sub-sites?

Can i add diagrams that illustrate task list found in the sub-sites?

Improve this question
2
  • Please add some questions regarding code or elaborate more to your scenario.
    – Pradip R.
    Commented Apr 25, 2018 at 6:04
  • 1
    @PradipR. please see updated question
    – Keshav Taurah
    Commented Apr 25, 2018 at 6:31

2 Answers 2

Reset to default
1

As it is SharePoint Online, the scenario you have mentioned is quite possible.

Out of the box(OOB):

You can use the CQWP web part(Content Query WebPart) which is OOB and does what you want, because you cannot take a list view outside its own site.

So you just add a CQWP webpart and in the properties give the site you want to pull data from and content type as Task list, then it will bring all the items from the task list of the current site and all its subsite. You can also filter more with additional queries in the webpart properties. Example here: When to use the Content Query Web Part or the Content Search Web Part in SharePoint

Custom Coding:

In custom development, you need to do is build up the code with the REST api to fetch data from your required subsite. I have done the same for one of my project. There are also other ways like creating provider hosted app and create client webparts in it, but I found this one as easy.

Here is an example to fetch data with REST api: Pull data from particular subsite and show on root site

Once you are able to fetch the data you can use any jQuery plugin or create one to show it in Chart view, timeline view, accordion etc.. Custom coding gives you more flexibility with UI to enhance it.

Improve this answer
5
  • I want to show the project summary web part that are in the sub sites in the root collection. Using the content search web part i only get a link to the list(only a small square is shown)
    – Keshav Taurah
    Commented Apr 25, 2018 at 9:46
  • do you know how i can add JavaScript to that,so that it only changes the color of a row base on certain value
    – Keshav Taurah
    Commented Apr 26, 2018 at 9:59
  • Yes its possible. here is the useful link: davidlozzi.com/2015/11/10/…
    – Pradip R.
    Commented Apr 26, 2018 at 10:16
  • What i want to know is how to target those result in the Display Template ?
    – Keshav Taurah
    Commented Apr 26, 2018 at 10:25
  • Please post separate question for the same.
    – Pradip R.
    Commented Apr 26, 2018 at 14:29
1

Content Search Web Part also can display sub sites list .

https://exploringsp2013.wordpress.com/2014/01/27/display-a-sub-site-list-using-a-content-search-web-part/

For your Scenario ,here is a demo about Using multiple lists in SharePoint Dashboard Designer

Improve this answer
2
  • any idea how long is the trial and what happens after that?
    – Keshav Taurah
    Commented Apr 25, 2018 at 8:46
  • do you know how i can add javascript to that,so that it only changes the color of a row base on certain value
    – Keshav Taurah
    Commented Apr 26, 2018 at 9:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.