Large files are one of the quietest risks in a SharePoint migration — until a restore window blows past estimate. This post shows how a CAML-based PowerShell scanner inventories your farm by size bucket before migration day, so nothing surprises you at execution.
Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.
✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions
Free to watch • No registration required • HD streaming
Le datasource :
<SharePointWebControls:SPDataSource
   ID="SPDataSource1"
   runat="server"
   DataSourceMode="Listoflists">
</SharePointWebControls:SPDataSource>
Rien de bien sorcier...
http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.webcontrols.spdatasource.datasourcemode.aspx
http://solutionizing.net/spdatasource-fields-for-webs-listsoflists/
La grid :
<asp:GridView
   ID="GridView1"
   runat="server"
   DataSourceID="SPDataSource1"
   AutoGenerateColumns="False" AllowSorting="True" AllowPaging="True" PageSize="2000" CellPadding="3" BorderStyle="Solid" BorderWidth="1px" HorizontalAlign="Left" EnableSortingAndPagingCallbacks="True">
   <Columns>
      <asp:boundfield DataField="__spBaseTemplate" HeaderText="Survey Type">
      </asp:boundfield>
      <asp:hyperlinkfield DataNavigateUrlFields="__spDefaultViewUrl" DataTextField="__spTitle" HeaderText="Survey Name">
      </asp:hyperlinkfield>
      <asp:boundfield DataField="__spCreated" HeaderText="Survey Date">
      </asp:boundfield>
      <asp:boundfield DataField="__spAuthor" HeaderText="Survey Author">
      </asp:boundfield>
   </Columns>
</asp:GridView>
Je recommande vivement ce petit outil : CAML Designer
ça devrait donner ça pour le SPDatasource :
<SharePoint:SPDataSource
   ID="SPDataSource1"
   runat="server"
   DataSourceMode="Listoflists"
   SelectCommand="<View><ViewFields><FieldRef Name='__spTitle'/><FieldRef Name='__spCreated'/><FieldRef Name='__spBaseTemplate'/><FieldRef Name='__spDefaultViewUrl'/></ViewFields><Query><OrderBy><FieldRef Name='Created' /></OrderBy><Where><Eq><FieldRef Name='__spBaseTemplate' /><Value Type='Text'>Survey</Value></Eq></Where></Query></View>">
</SharePoint:SPDataSource>
Et bien non.... le selectcommand n'est absolument pas pris en compte pour le mode Listoflist...
<SharePointWebControls:SPDataSource
   ID="SPDataSource1"
   runat="server"
   DataSourceMode="Listoflists" UseServerDataFormat="True">
</SharePointWebControls:SPDataSource>
<div id="surveylist" style="display:none;">
<asp:GridView
   ID="GridView1"
   runat="server"
   DataSourceID="SPDataSource1"
   AutoGenerateColumns="False" AllowSorting="True" AllowPaging="True" PageSize="2000" CellPadding="3" BorderStyle="Solid" BorderWidth="1px" HorizontalAlign="Left" EnableSortingAndPagingCallbacks="True">
   <Columns>
      <asp:boundfield DataField="__spBaseTemplate" HeaderText="Survey Type">
      </asp:boundfield>
      <asp:hyperlinkfield DataNavigateUrlFields="__spDefaultViewUrl" DataTextField="__spTitle" HeaderText="Survey Name">
      </asp:hyperlinkfield>
      <asp:boundfield DataField="__spCreated" HeaderText="Survey Date">
      </asp:boundfield>
      <asp:boundfield DataField="__spAuthor" HeaderText="Survey Author">
      </asp:boundfield>
   </Columns>
</asp:GridView>
</div>
<script type="text/javascript">
$(document).ready(function() {
 $("tr th:first-child").hide();
 $("tr td:first-child").hide();
 $("tr td:first-child:not(:contains('Survey'))").closest('tr').hide();
 $("#surveylist th").css('text-align','left');
 $("#surveylist").show();
});
</script>
Ça donne ça :
Si jamais quelqu'un a une solution plus "propre", je suis preneur :)
