Tag Info

Hot answers tagged

3

You can export the lists in Excel sheets. Combine them and create another list using the combined excel sheet. This way will only allow you to combine data upto that particular point of time. i.e, its not dynamic. You can combine lists using a Data view web part creating a new linked resource. Refer this blog for details. And afterwards you can export this ...


2

There isn't anything in the SPD GUI to accomplish this. You would need to do it like you are doing it in the XSLT. Other way would be to use a Visual Studio solution, but you would be doing even more code that way.


2

It is possible to transform specified result, the following function could be used for that purpose (jQuery is used): //Filter results by Parent function filteredByParent(entries) { var filteredEntries = []; var childEntries = []; $.each(entries, function (i, entry) { var groupKey = entry.Parent; if (typeof ...


1

For such complex cases you might need to create DataContext and use Linq to SharePoint.. SPMetal command utility is used to create .CS code file for Entity Context.. Using this generated class you can easily query using LINQ.. Have a look at these: Using LINQ to SharePoint How to: Query Using LINQ to SharePoint


1

Yes, you can do this by SharePoint Designer. Add a lookup column to the Orders list, which will refer to the Customers list Open Customers list in SharePoint Designer Edit Customers Display Form, from the toolbar, select Insert a "Related Item View", your Orders list should show up in the option list, choose it Add/Remove columns of the Orders view You ...


1

I would use SPServices to get the data you want and construct two javascript objects and display using jquery. If you have 3rd party control plugins like KendoUI you could simply attach the grid controls to your return objects. Since the grids support filtering, sorting, and grouping, you would only have to skin them to look closer to sharepoint.


1

You'd want to do something like: <xsl:variable name="Rows" select="../../../Courses_Attended/Rows/Row[substring-before(substring-after(@Attendee, 'ID='), '&quot;')=$dvt_ParentRow/substring-before(substring-after(@Person, 'ID='), '&quot;')]" />


1

Yes you can, in your Joins node add a Join with type="LEFT", something like this: <Join Type="LEFT" ListAlias="h"> <Eq> <FieldRef Name="Canteen" RefType="Id" /> <FieldRef List="v_location" Name="CanteenNum" /> </Eq> </Join> Here is a good example You also may want to look into using LINQ to ...


1

Larisa, CAML Query do allow LEFT joins using <Join> tag... See Joins and Projections article on MSDN... In Join there is a Type attribute whose value can either be INNER or LEFT, see JOIN... If you can't figure out, I can give your complete CAML Query... Let me know!


1

If you use CSOM, you can only use the client side transformation to create tree structured objects. You have a good working example from @vgrem. Just for completeness I want to provide a javascript function which doesn't have the jQuery dependency: function transform(items) { var transformed = [], childEntries = [], i = 0, len = ...


1

This is assuming you are using SharePont Designer 2010; I would advise that you use the "Extract Substring from Index of String" Action. This will allow you copy the ReqID value into a custom variable, trim that variable, then use the edited variable as your filter.Some thing like the below "Copy from [Current Item:ReqID], starting at 4 (Output to ...


1

You can absolutely create joined views, but there's no way to do what you would think of as a real "join". What you end up with, even if you just add a Joined Subview with the ribbon options, is a sort of filtering of the items in the second list based on the current value of a column (or columns) in the first list. I create DVWPs all the time with two or ...


1

There isn't way for that to directly export to Excel. However, as iOnline247 mentioned, you can use jQuery to convert the HTML table on the page to CSV. Then you can save that and open it with Excel: http://www.kunalbabre.com/projects/table2CSV.php



Only top voted, non community-wiki answers of a minimum length are eligible