Question

mafab on Thu, 19 Apr 2018 21:20:12


Hi,

this question is actually for sharepoint online site, but since I didn't find exact location , so posting here.

Q - I have a ProjectInfo list with few columns (status,name,year,etc) in all 25 subsites in same sitecollection.

How can get a rollup of this list in top site to show as dashboard. (if possible ,can able to filter on status).

Is there any easy way out.

kind Regards


Sponsored



Replies

Lee__li on Fri, 20 Apr 2018 01:38:10


Hi,

You could try to use search REST api to query all items based on content type.

Here are some threads for your reference.

https://sharepoint.stackexchange.com/questions/234200/rest-api-to-pull-all-list-items-that-uses-a-unique-content-type-under-a-specific

https://docs.microsoft.com/en-us/sharepoint/dev/general-development/sharepoint-search-rest-api-overview

When you got data, build dashboard by JavaScript library such as https://developers.google.com/chart/ .

Best Regards,

Lee