Posts in category: General SharePoint

I could not find a good example of how to do this so here is my solution. Hopefully it will be helpful to someone. Here is a quick example of how to retreive data from a list with SP services and then filter the results before displaying them. In my example I needed to get the data from a list but display part of it in two different places on the page

// normal sp spervices call to the list 
function getFooterLnks() {
$().SPServices({
operation: "GetListItems",
async: false,
listName: "Links",
completefunc: function(xData, Status) {
// this function runs on the data we get back    
    getDataFooter(xData, Status,colArray);
}
});
}

function getDataFooter(xData, Status) {

// putting the data into a Json object 

var myJson = $(xData.responseXML).SPFilterNode("z:row").SPXmlToJson({
mapping: {
ows_Title: {mappedName: "Title", objectType: "Text"},
ows_Column: {mappedName: "Column", objectType: "Text"},
ows_Url: {mappedName: "Url", objectType: "Text"},
ows_Cat: {mappedName: "Category", objectType: "MultiChoice"}
},
includeAllAttrs: false
});

// now we need to filter the Json object the col variable holds the term I want to filter by

var col = "Category 1";

// check if the value appears in the Json

myJsonResults = $(myJson).filter(function(){
return this.Category[0].indexOf(col) !== -1;
});

// put each of the results in an object with html formatting

var items = [];
$.each(myJsonRes, function() {
items.push("
<ul>
	<li><a title="" href="&quot; + this[">" + this['Title'] + "</a></li>
</ul>
&nbsp;

");
});

");
});
$('#linksWrapper').append(items);

}

So you are trying to remove indexing from a lookup column in a SharePoint list and you get an error like this:

Very helpful error message

The problem is that the column has relationship behaviors turned on. Go to the list settings and turn it off. Enjoy the rest of your day.

Relationship Behavior

In SharePoint 2007 when a document library has required columns for metadata or other information the user is prompted to complete the information when a new document is added. However if the user chooses the ‘Upload Multiple Files” option they are not required to populate required columns. After the files are load and a user goes in to edit they will be prompted to fill in the information.

In some cases this may not be an issue but if the library has workflows triggered by column values or views sorted or filtered based on those metadata columns there could be problems. So of course there is use training that can be done to ensure documents are always properly populated with metadata but sometimes that is not enough.