Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [aggregation]

A set of content, features or data composed of many distinct parts or compiled from different sources.

1
vote
1answer
70 views

Newsfeed aggregation - extend time range

We got SharePoint 2016 on premise with May 2018 patch level. Our Newsfeed aggregation on the personal sites today is showing followed content of the last 7 days if you click "show more" on the bottom ...
1
vote
0answers
173 views

CSOM (HighTrust) SP2013 Group by aggregate giving duplicates

Hi I've been reading about group by in SharePoint 2013 CSOM from this article here. https://piyushksingh.com/2016/11/21/retrieve-grouped-listitems-sharepoint I've recently upgraded to 2013 and though ...
1
vote
1answer
33 views

Compile data from multiple sources into a SharePoint List

I have data stored in a local network database (SQL Express, connected to our MRP system), Excel files on a local file server, and on Teamwork.com project management site. I would like to combine data ...
0
votes
1answer
78 views

List aggregation formatting problem

I'm a bit of a SharePoint beginner, so please forgive me if this is a very basic question. I have a parent site with a number of identical team sites below it. The requirement is that each team site ...
1
vote
1answer
46 views

Roll-up data from a restricted subsite to parent site

One of my Site Owners has requested a feature to roll-up data from a restricted list. The list is located in a restricted subsite. They want a short summary to roll-up to the parent site. They don´t ...
1
vote
2answers
787 views

Roll up large amount of data from multiple lists

I have a site with several hundred of lists and over 100,000 items in total. I need a content roll up of the data to track the amount of items created per month/year. I already took a look into: ...
1
vote
1answer
55 views

Aggregating 25 lists into one main list

I've been asked to create 25 lists and sub-sites for each department in my organization and then roll all those 25 lists into 1 master list. I'm currently using SharePoint 2010 Standard. I don't ...
2
votes
2answers
109 views

Aggregating User's Tasks in SharePoint 2013

I have been scouring the internet for that past several weeks trying to come up with a solution, but I am lost. I need a web part that can do two things: Display all incomplete tasks for a specific ...
1
vote
1answer
163 views

SPSiteDataQuery for Task List not working

I am creating a visual web part for aggregating all task in all webs of a site collection I am using SPSiteDataQuery to get all tasks but it does not work for Task list i.e. Task List query....
2
votes
2answers
299 views

Modify Aggregation Panel view

how can I modify aggregation panel items? I need to hide Title of current calendar (see picture below). I've got Sharepoint Online 2013. I try it in Sharepoint Designer. But I don't want to hide all ...
1
vote
2answers
253 views

Best practices for creating views or separate lists?

Is there a best practice that can be said for whether to add a tag and have users filter on it or just create a separate list? We have many groups in our SharePoint application that all have many ...
2
votes
1answer
543 views

WorkManagement API TypeError: this.get_context is not a function

I have one requirement to show the aggregated task list as a webpart in any page of SP 2013 on premise, where user will see the assigned task list directly without going onto my site. After some ...
0
votes
1answer
547 views

Why is my list total showing as “Count= undefined”?

I'm updating a view on an existing list programmatically but I can't get the aggregation to work correctly. I'm setting it as follows (the values are pulled from an xml site definition): if (...
0
votes
0answers
594 views

Combined Tasks List Data View Web Part - SharePoint Designer 2013

I am looking to create a list that will show all outstanding tasks from multiple Task lists that are in multiple site-collections in Sharepoint Online/Office 365. I am aware that there are 3rd party ...
0
votes
2answers
52 views

Aggregation as a separate step from Presentation

I am wondering if anyone knows of any (SharePoint 2010) COTS or OOTB ways of doing list aggregation/rollup that can be done separately from the Presentation layer? Context: I have used a number of ...
5
votes
2answers
35k views

How to show additional fields within the Content Query Web Part

I'm trying to use the Content Query Web Part to display all the tasks within a site collection, I've attached images of the Web Part properties and final output below. I'm looking for information on ...
1
vote
0answers
114 views

Set default Value of List Lookup Column based on Site Name

I've built a series of Project Sub-sites, each with a Task list that includes the Project Name. The sub-site name is also the project name. How can I set the default value of the Project Lookup ...
7
votes
2answers
918 views

Is it possible to have different timeline views against the same list?

Using a single task list, from our testing it seems that the add to timeline/remove from timeline functions store state across the site list rather than against the view. Is it possible to select a ...
1
vote
2answers
649 views

View aggregations programmatically

I have a view in my list, I defined aggregations in my view: sum and average of several columns. Now I want to get programmatically the aggregations results. How can I get it?
1
vote
2answers
1k views

Constructing a link in a dataform webpart

I've setup a DataFormWebPart which aggregates tasks from subsites. The user doesn't only want to view the tasks, there should be an option to edit / open them as well. So I need a way to at least ...
0
votes
1answer
1k views

Summing a column on a DVWP with 2 levels of grouping with incorrect subtotals

I am working with SharePoint 2007, and have been charged with making a report based on external data (SQL Server). It is a high level look at list of tickets in particular statuses. I decided to go ...
2
votes
1answer
1k views

Universal Task List

I suspect I am over-complicating this issue. At least it seems like such an obvious need that I would expect an obvious, pre-existing solution. Specifically, we want the user to be able to ...
0
votes
1answer
317 views

Effectively Querying Subsite RootFolder.Properties

I'm storing some data in the RootFolder.Properties for a bunch of subsites, sub-subsites and sub-sub-subsites. On the parent site(s), I want to roll up that data, security trimmed for the user. (All ...
0
votes
1answer
152 views

Aggregating lists based on content type

We've got some lists that we plan to aggregate using a content query web part (CQWP) later, using a custom content type. The content type will be used on numerous sites within a site collection, but ...
1
vote
1answer
615 views

Advanced filtering in the ContentByQueryWebPart

I have a webpartpage with two CQWPs. I want the first to show all pages for the current site, and I want the second to show all pages for the subsites of the current site. As I can see, there's no ...
1
vote
2answers
170 views

RSS from the whole Sharepoint portal

It would be nice to have an RSS feed from the whole Sharepoint portal, all lists, webs which a current user has access to. Any ideas?
4
votes
2answers
217 views

RSS enabled web part

We are rolling up content from multiple site collections and are looking for a way to allow a RSS feed from that rolled up content. Any ideas on implementation of a RSS option for a custom webpart? ...
2
votes
1answer
598 views

aggregate data source and pseudo join?

Is it possible to use the aggregatedatasource to show all "parents" and theirs "children" where at least one "children" is created by the current user ? To be more clear, imagine the following : ...
0
votes
2answers
1k views

Site Aggregator web part in SP2010 does not show new tab

I am unable to find "new tab" after adding Site Aggregator web part. Does anyone know how to do it?
2
votes
1answer
3k views

Aggregating SharePoint lists

We are designing a system with a national level, regional level and a sub-regional level. We plan to implement this with a site structure with sub-sites and sub-sub-sites. The sites at the lowest ...
4
votes
1answer
2k views

Content Query Web Part not rendering calendar list description field

We have a SP2010 site that we are making extensive use of the CQWP (Content Query Web Part) on. When I point the CQWP at a specific list it displays description value fine. The problem is when I point ...
5
votes
5answers
4k views

Tasks Roll up across Farm, site collection

We have OOTB "task lists" in many sites used by the same set of users. We have a farm with "x" site collections and "x" sites with-in them without any changes to the default content type. We would ...
2
votes
3answers
203 views

SP 2007 - creating a 'blogfall' of all recent blog posts from mysite blogs

I want to aggregate into one webpart the posts made by staff on their mysite blogs. This basically allows me to present the internal musings of staff to all staff. What I am trying to do is elevate ...
0
votes
1answer
2k views

XSLT for summing Number column where there are cells with no value

This is akin to this question but I couldn't get the suggested sumAll function to work. I also have several different columns to sum and it just seems silly to have a separate template for each ...
2
votes
1answer
1k views

Content aggregation: Same document library in several subsites into one big document library in main site

Let's say I have a main site collection with three subsites each having one document library: MainSite SubSite1 (myDocLib) SubSite2 (myDocLib) SubSite3 (myDocLib) I want three subsites for security ...
0
votes
1answer
759 views

How do I filter on a sum in a group footer? (Data View Web Part)

I have a DVWP that displays groups of data. For each group, I've got a sum of one of the columns. This sum exists in the group footer in a template called dvt_1.groupfooter0. <xsl:variable name="...
2
votes
1answer
354 views

Summary of recent events web part

How can I acumulate recent changes on one single start page. I want to see latest changes as a single stream, with things coming from various lists like news, forums, document libraries etc etc and I ...
0
votes
2answers
5k views

How do I create DVWP showing multiple lists with latest item from each list?

We have a MOSS site which is using a DVWP to pull in from multiple subsites' list items to display as a calculated field KPI set (just as Christophe has suggested on his forum page). This works great,...
2
votes
2answers
670 views

How do I query several lists with the Object Model and merge the results?

Is it possible to with the Object Model query several lists at the same time and get the result merged together? Something like linked sources in SharePoint Designer? I have created a web part that ...
11
votes
6answers
31k views

How to aggregate events from multiple calendars to master calendar?

Across a site collection, various sites maintain their own calendars. Meanwhile, users have requested that events for those subgroups be aggregated and displayed on a master calendar. Question: Out-...