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 ...


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

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

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

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