Hot answers tagged joined-view
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
1
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 ...
Only top voted, non community-wiki answers of a minimum length are eligible
