No Data - Please provide an example

Oct 19, 2010 at 4:53 PM

Hi,

I’m trying to use your component to join a couple of lists but I’m not getting any data back.  I’m not sure where to put the AggregateDataSource tag as I can’t find any examples where you are using the AggregateDataSource with a SPDataSource and your  RollUpDataFormWebPart.  Thanks in advance for looking at this.

Here’s my code:

 

<WebParts:AggregateDataSource runat="server" ID="aggDSC">

<Sources>

                       

<SharePoint:SPDataSource ID="EOB" runat="server" DataSourceMode="List" UseInternalName="true" selectcommand="&lt;View&gt;&lt;/View&gt;"><SelectParameters><WebPartPages:DataFormParameter Name="ListID" ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{24ECEC38-12FB-4480-B019-84206220AA5D}" /></SelectParameters><DeleteParameters><WebPartPages:DataFormParameter Name="ListID" ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{24ECEC38-12FB-4480-B019-84206220AA5D}" /></DeleteParameters><UpdateParameters><WebPartPages:DataFormParameter Name="ListID" ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{24ECEC38-12FB-4480-B019-84206220AA5D}" /></UpdateParameters><InsertParameters><WebPartPages:DataFormParameter Name="ListID" ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{24ECEC38-12FB-4480-B019-84206220AA5D}" /></InsertParameters></SharePoint:SPDataSource>

            <SharePoint:SPDataSource ID="EOBWF" runat="server" DataSourceMode="List" UseInternalName="true" selectcommand="&lt;View&gt;&lt;/View&gt;"><SelectParameters><asp:Parameter Name="ListID" DefaultValue="{0B5B5ED4-16B8-4A0D-9E0E-CF4720D69FCC}" /></SelectParameters><DeleteParameters><asp:Parameter Name="ListID" DefaultValue="{0B5B5ED4-16B8-4A0D-9E0E-CF4720D69FCC}" /></DeleteParameters><UpdateParameters><asp:Parameter Name="ListID" DefaultValue="{0B5B5ED4-16B8-4A0D-9E0E-CF4720D69FCC}" /></UpdateParameters><InsertParameters><asp:Parameter Name="ListID" DefaultValue="{0B5B5ED4-16B8-4A0D-9E0E-CF4720D69FCC}" /></InsertParameters></SharePoint:SPDataSource>

</Sources>

 

<Aggregate>

     <join left="EOB" right="EOBWF" on="FileLeafRef=EOBFormName" Type="Left"></join>

</Aggregate>

 

</WebParts:AggregateDataSource>

 

                        <WebParts:RollUpDataFormWebPart DataSourceID="aggDSC" runat="server" SuppressWebPartChrome="False" Description="Use to display dynamic content views from a collection of sites. The results are displayed in the Data Form Web Part." PartImageSmall="" FrameType="Default" Debug="True" DetailLink="" ExportControlledProperties="True" IsVisible="True" AllowRemove="True" AllowEdit="True" ID="g_5ef914a9_333c_4413_b569_d5a135a25772" Dir="Default" FrameState="Normal" FixSorting="True" ViewContentTypeId="" MissingAssembly="Cannot import this Web Part." AllowConnect="True" PageSize="-1" AllowMinimize="True" IsIncludedFilter="" ShowWithSampleData="False" HelpMode="Modeless" ExportMode="All" Title="Rollup Content Data View" HelpLink="" AllowHide="True" AllowZoneChange="True" PartOrder="0" UseSQLDataSourcePaging="True" PartImageLarge="" IsIncluded="True" NoDefaultStyle="" __MarkupType="vsattributemarkup" __WebPartId="{5EF914A9-333C-4413-B569-D5A135A25772}" __AllowXSLTEditing="true" WebPart="true" Height="" Width="">

<ParameterBindings>

      <ParameterBinding Name="dvt_apos" Location="Postback;Connection"/>

      <ParameterBinding Name="UserID" Location="CAMLVariable" DefaultValue="CurrentUserName"/>

      <ParameterBinding Name="Today" Location="CAMLVariable" DefaultValue="CurrentDate"/>

      <ParameterBinding Name="dvt_firstrow" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_nextpagedata" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_adhocmode" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_adhocfiltermode" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_filterfield" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_filtertype" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_filterval" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_groupdir" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_groupdisplay" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_groupfield" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_groupsorttype" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_grouptype" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_sortdir" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_sortfield" Location="Postback;Connection"/>

      <ParameterBinding Name="dvt_sorttype" Location="Postback;Connection"/>

</ParameterBindings>

<DataFields>@FileLeafRef,Name (for use in forms);@Title,Title;@All_x0020_Tasks_x0020_Completed,All Tasks Completed;@Benefits_x0020_BEICW,Benefits BEICW;@Benefits_x0020_BEIPS,Benefits BEIPS;@Benefits_x0020_CEACA,Benefits CEACA;@Benefits_x0020_DFAWFFDEAATKS,Benefits DFAWFFDEAATKS;@Benefits_x0020_DUTELA,Benefits DUTELA;@Benefits_x0020_EEFEI,Benefits EEFEI;@Benefits_x0020_EFRC,Benefits EFRC;@Benefits_x0020_EWANP,Benefits EWANP;@Benefits_x0020_PEACA,Benefits PEACA;@Benefits_x0020_SEWTKSUTNHACCS,Benefits SEWTKSUTNHACCS;@Benefits_x0020_Task_x0020_Completed,Benefits Task Completed;@Hiring_x0020_Manager_x0020_Task_x0020_Completed,Hiring Manager Task Completed;@HR_x0020_ATMHRD,HR ATMHRD;@HR_x0020_ATOR,HR ATOR;@HR_x0020_BPS,HR BPS;@HR_x0020_COE,HR COE;@HR_x0020_DUTEL,HR DUTEL;@HR_x0020_EEOCECR,HR EEOCECR;@HR_x0020_EOR,HR EOR;@HR_x0020_HA,HR HA;@HR_x0020_I_x0020_9_x0020_DEC,HR I 9 DEC;@HR_x0020_IIPS,HR IIPS;@HR_x0020_MCOBC,HR MCOBC;@HR_x0020_OBC,HR OBC;@HR_x0020_OESWDR,HR OESWDR;@HR_x0020_OOLR,HR OOLR;@HR_x0020_OPS,HR OPS;@HR_x0020_Payroll_x0020_Accountant_x0020_Task_x0020_Completed,HR Payroll Accountant Task Completed;@HR_x0020_POVI,HR POVI;@HR_x0020_Project_x0020_Administrator_x0020_Task_x0020_Completed,HR Project Administrator Task Completed;@HR_x0020_PT,HR PT;@HR_x0020_ROAF,HR ROAF;@HR_x0020_ROHCWCADC,HR ROHCWCADC;@HR_x0020_RRP,HR RRP;@HR_x0020_SWP,HR SWP;@HR_x0020_VI_x0020_9,HR VI 9;@HR_x0020_WCA,HR WCA;@HRTask_x0020_Completed,HRTask Completed;@IT_x0020_Database_x0020_Manager_x0020_Task_x0020_Completed,IT Database Manager Task Completed;@IT_x0020_Help_x0020_Desk_x0020_Supervisor_x0020_Task_x0020_Completed,IT Help Desk Supervisor Task Completed;@LMS_x0020_Project_x0020_Manager_x0020_Task_x0020_Completed,LMS Project Manager Task Completed;@Orientation_x0020_Administrator_x0020_Task_x0020_Completed,Orientation Administrator Task Completed;@Other_x0020_Tasks_x0020_Completed,Other Tasks Completed;@Recruiter_x0020_Task_x0020_Completed,Recruiter Task Completed;@Unique_x0020_ID,Unique ID;@MeritEOB,Merit EOB Workflow;@EOBFormName,EOB Form Name;@Recruiter_x0020_EFHMWOD0,Recruiter EFHMWOD;@Recruiter_x0020_NHDETC0,Recruiter NHDETC;@Recruiter_x0020_SOLR0,Recruiter SOLR;@Recruiter_x0020_Application0,Recruiter Application;@Recruiter_x0020_Resume0,Recruiter Resume;@Recruiter_x0020_RCOC0,Recruiter RCOC;@Recruiter_x0020_MAAENM0,Recruiter MAAENM;@Recruiter_x0020_CA0,Recruiter CA;@Recruiter_x0020_W_x0020_40,Recruiter W 4;@Recruiter_x0020_I_x0020_9_x0020_EPC0,Recruiter I 9 EPC;@Recruiter_x0020_BAFRCFC0,Recruiter BAFRCFC;@Recruiter_x0020_AFSTEBI0,Recruiter AFSTEBI;@Recruiter_x0020_BCRAAFE0,Recruiter BCRAAFE;@Recruiter_x0020_EEFMPR0,Recruiter EEFMPR;@Recruiter_x0020_CHMTVESOHD0,Recruiter CHMTVESOHD;@Hiring_x0020_Manager_x0020_Task_x0020_Completed0,Hiring Manager Task Completed;@ID,ID;@ContentType,Content Type;@Created,Created;@Author,Created By;@Modified,Modified;@Editor,Modified By;@_CopySource,Copy Source;@CheckoutUser,Checked Out To;@_CheckinComment,Check In Comment;@CheckedOutTitle,Checked Out To;@CheckedOutUserId,ID of the User who has the item Checked Out;@FileDirRef,Path;@FSObjType,Item Type;@HTML_x0020_File_x0020_Type,HTML File Type;@File_x0020_Type,File Type;@IsCheckedoutToLocal,Is Checked out to local;@_SourceUrl,Source Url;@_HasCopyDestinations,Has Copy Destinations;@ContentTypeId,Content Type ID;@_ModerationStatus,Approval Status;@_UIVersion,UI Version;@Created_x0020_Date,Created;@FileRef,URL Path;@File_x0020_Size,File Size;@_UIVersionString,Version;@ParentVersionString,Source Version (Converted Document);@ParentLeafName,Source Name (Converted Document);@TemplateUrl,Template Link;</DataFields>

<Xsl>

 

Thanks,

Coordinator
Oct 20, 2010 at 3:47 PM

the custom Aggregate Data Source you are using was not designed to work with the OTB SPDataSource. Since you are pulling data out of single lists, you may want to replace the SPDataSources with RollupDataSources configured with a rollup scope of Web and pointing to the same respective lists.

Your scenario also allows you to use the OTB AggregateDataSource that works with SPDataSources through SharePoint Designer

v

Oct 20, 2010 at 5:30 PM

OK then that makes sense why it isn’t working. I believe I have to use PS AggregateDataSource since the OTB one doesn’t support joins. That is unless I’m missing something. Can you send me an example of how to use the RollupDataSource or point me in the right direction?  I only see examples using the CrossSiteDataSource.

Thanks for your response.

Oct 20, 2010 at 6:15 PM
Edited Oct 20, 2010 at 6:25 PM

I believe Val was recommending using one of the Rollup Data Sources in place of the SPDataSource as opposed to specifically recommending using the RollUpDataSource-

Here is an example RollUpDataSource that can be plugged in as a source for the AggregateDataSource. However, the CrossSiteDataSource is recommended over the RollUpDataSource which should only be used as a last resort if the CrossSiteDataSource is not returning any data-
http://portalsolutions.codeplex.com/wikipage?title=RollUpDataSource&referringTitle=RollUp%20WebParts

 

Coordinator
Oct 21, 2010 at 3:31 PM

@epranav: I was specifically referring to the use of the RollUpDataSource. In the context of pulling informaiton out of a single list, on a query not exceeding 2000 items, it is just as performant as the CrossSiteDataSource b/c the same number of SPSite/SPWeb objects is opened (one pair).

@ehalsey: the link suggested by Pranav should get you started.

<WebParts:AggregateDataSource runat="server" ID="aggDSC">

<Sources>

<cc1:RollUpDataSource runat="server" Lists="EOB" TopLevelSite="/path/to/the/site" Scope="Web" FixLookups="True" IncludeListData="False"  QueryRowLimit="10" ID="EOB">
     <Fields>
          <FieldRef Name="Mention" />
          <FieldRef Name="all" />          <FieldRef Name="fields" />  <FieldRef Name="FileLeafRef" />


     </Fields>
     <Query/>
</cc1:RollUpDataSource>

<cc1:RollUpDataSource runat="server" Lists="EOBWF" TopLevelSite="/path/to/the/site" Scope="Web" FixLookups="True" IncludeListData="False"  QueryRowLimit="10" ID="EOBWF">
     <Fields>
          <FieldRef Name="Mention" />
          <FieldRef Name="all" />          <FieldRef Name="fields" />  <FieldRef Name="EOBFormName" />


     </Fields>
     <Query/>
</cc1:RollUpDataSource>

 </Sources>

<Aggregate>

     <join left="EOB" right="EOBWF" on="FileLeafRef=EOBFormName" Type="Left"></join>

</Aggregate>

</WebParts:AggregateDataSource>

Oct 21, 2010 at 9:05 PM

Thanks I think I'm almost there!  Something strange is happening though.  In SharePoint Designer it works I can see the joined data, however when I save the file and view it in the browser it only shows the Title field and shows all data in the site.  Its like it doesn't see the AggregateDataSource and is defaulting to all site data.  I have some screenshots if you need those.

Oct 21, 2010 at 9:15 PM

OK I fixed it but I'm not sure if it is the right way to do it.  I included the AggregateDataSource in the <DataSources> element of the Rollup Content Data View and it appears to work.  When just referencing the datasource by specifying the DatasourceID it did not.