Issue with retrieving items from a list in another site (within the same site collection)

May 5, 2011 at 9:13 PM
Edited May 5, 2011 at 9:15 PM

Hi Marc,

Using WSS 3.0, jQuery v1.4.2 & SPServices v0.6.1

I’m displaying data from a XML Web Services data source, and using JSON to fill in some extra info from a list located in another site.

Issue 1:   List name is “Service Change Request/Notice (SCR or SCN)” use of that name results in no records returned using the GetListItems operation.   Whereas, if I use the GUID for list as displayed in the list settings URL, I get the expected results.   Are there any restricted/reserved characters in my List Name ?

Issue 2 (Main): The ‘extra info’ from GetListItems operation only shows up on my screen. The ‘extra info’ does not appear for the other team members regardless of permissions [farm admin, full control, and contributor].

	operation: "GetListItems",
	webURL: "",
	listName: "{918C7EB5-6F2B-4140-8842-723BD0FA935B}",
	CAMLQuery: camlQuery,
	CAMLViewFields: "<ViewFields><FieldRef Name='Title' /><FieldRef Name='Review_x0020_Status' /><FieldRef Name='_ModerationStatus' /><FieldRef Name='ID' /></ViewFields>",
	// Override the default view rowlimit and get all appropriate rows
	CAMLRowLimit: 0,
	completefunc: function(xData, Status) {
		$(xData.responseXML).find("[nodeName='z:row']").each(function() {
			var taskNumber = $(this).attr("ows_Title");
			var itemID = $(this).attr("ows_ID");
			var approvalStatus = $(this).attr("ows__ModerationStatus"); 
			var reviewStatus = $(this).attr("ows_Review_x0020_Status"); 
			taskNumber = jQuery.trim(taskNumber);
			if(taskNumber.length > 0){
				$('a.task-link:contains["'+taskNumber+'"]').each(function() {
					if( jQuery.trim($(this).text()) == taskNumber ){
						var scrCell = $(this).parents('tr:first').find('td.scr-cell');
						scrCell.html('<a target="_SCR" href="/depts/Operations/IS/Programming/Lists/SCN/DispForm.aspx?ID='+itemID +'">' + taskNumber+"</a>");

I've confirmed the camlQuery is correct.
I've confirmed my team and I are getting the info up to the point of the GetListItems operation.

Any help would be appreciated,


May 9, 2011 at 1:14 AM


Issue 1: You should always check what you are getting back from the GetListItems call to see what the error might be. I just created a list in my test environment and was able to use this code successfully:

    operation: "UpdateListItems",
    async: false,
    listName: "Service Change Request/Notice (SCR or SCN)",
    ID: 1,
    valuepairs: [["Lead_x0020_Date", "2011-05-08 12:12:12"]],
    completefunc: function (xData, Status) {
} });

Issue 2: You've lost me a bit with the 'extra info' bit. My guess is that there is something different about what you see in the DOM and what others see, causing the difference. Maybe the selectors are finding something different than you intend?


May 10, 2011 at 6:56 PM
Edited May 10, 2011 at 6:56 PM


Sorry about that...  the 'extra info' was referring to the data from "Service Change Request/Notice (SCR or SCN)",  as I was adding some data from that list into an existing DVWP.

Seems my issue # 2  seems to be fine now...  I recreated the webparts and pasted the XSL & JavaScript/jQuery back in and it works fine.  Unfortunately, I'm not sure what is different.

I haven't had a chance to checkout the listname issue, but now that main issue is working, I'm going to take a look.

May 10, 2011 at 8:39 PM
Edited May 10, 2011 at 8:47 PM

Looks like I spoke too soon...

I wrote out xData.responseXML.xml  with the listName parameter equal to the GUID

I and a couple of others get the following 

<?xml version="1.0"?><soap:Envelope xmlns:soap="" xmlns:xsi="" xmlns:xsd=""><soap:Body><GetListItemsResponse xmlns=""><GetListItemsResult><listitems xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"><rs:data ItemCount="4">						
<z:row ows_Title="12894" ows_Review_x0020_Status="Approved" ows__ModerationStatus="0" ows_ID="4900" ows_BA="19;#Jane Doe" ows_MetaInfo="4900;#vti_encoding:SR|utf8-nlWorkflowCreationPath:SW|1d898d9c-e98a-43ea-92ef-3902015ad794,5;" ows__Level="1" ows_Programmer="13;#Randy Doe" ows_owshiddenversion="5" ows_UniqueId="4900;#{DFC9693A-47CD-48FC-9A22-A89FE1230646}" ows_FSObjType="4900;#0" ows_Created="2011-05-03 16:40:56" ows_FileRef="4900;#depts/Operations/IS/Programming/Lists/SCN/4900_.000"/>						
<z:row ows_Title="12553" ows_Review_x0020_Status="Approved" ows__ModerationStatus="0" ows_ID="4911" ows_BA="19;#Jane Doe" ows_MetaInfo="4911;#vti_encoding:SR|utf8-nlWorkflowCreationPath:SW|1d898d9c-e98a-43ea-92ef-3902015ad794,8;" ows__Level="1" ows_Programmer="3;#Juan Doe" ows_owshiddenversion="8" ows_UniqueId="4911;#{7995788B-3339-4120-833E-C2AD52C8C90D}" ows_FSObjType="4911;#0" ows_Created="2011-05-04 15:18:16" ows_FileRef="4911;#depts/Operations/IS/Programming/Lists/SCN/4911_.000"/>						
<z:row ows_Title="12772" ows_Review_x0020_Status="Approved" ows__ModerationStatus="0" ows_ID="4918" ows_BA="34;#Jen Doe" ows_MetaInfo="4918;#vti_encoding:SR|utf8-nlWorkflowCreationPath:SW|1d898d9c-e98a-43ea-92ef-3902015ad794,5;" ows__Level="1" ows_Programmer="3;#Juan Doe" ows_owshiddenversion="5" ows_UniqueId="4918;#{780A9AA1-A15E-45C1-88A4-FC1E1335DC70}" ows_FSObjType="4918;#0" ows_Created="2011-05-05 11:59:20" ows_FileRef="4918;#depts/Operations/IS/Programming/Lists/SCN/4918_.000"/>						
<z:row ows_Title="12948" ows_Review_x0020_Status="Approved" ows__ModerationStatus="0" ows_ID="4923" ows_BA="19;#Jane Doe" ows_MetaInfo="4923;#vti_encoding:SR|utf8-nlWorkflowCreationPath:SW|1d898d9c-e98a-43ea-92ef-3902015ad794,4;" ows__Level="1" ows_Programmer="3;#Juan Doe" ows_owshiddenversion="4" ows_UniqueId="4923;#{4F3D293E-118A-4108-9BEB-625F7446343D}" ows_FSObjType="4923;#0" ows_Created="2011-05-06 06:18:45" ows_FileRef="4923;#depts/Operations/IS/Programming/Lists/SCN/4923_.000"/></rs:data>

However other members of the group get the following:

<?xml version="1.0"?><soap:Envelope xmlns:soap="" xmlns:xsi="" xmlns:xsd=""><soap:Body><GetListItemsResponse xmlns=""><GetListItemsResult><listitems xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<rs:data ItemCount="0"></rs:data>

With the listName parameter set to the list name "Service Change Request/Notice (SCR or SCN)", we all get

<?xml version="1.0"?><soap:Envelope xmlns:soap="" xmlns:xsi="" xmlns:xsd=""><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.</faultstring><detail><errorstring xmlns="">Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).</errorstring></detail></soap:Fault></soap:Body></soap:Envelope>
Those of use that the GUID works, have IE 8 installed.  The rest have IE 7.
May 10, 2011 at 9:00 PM

I also checked selectors as you suggested, but if the SOAP response is empty it explains why it doesn't show up.  Just in case, I added


and the word Hello showed up in the correct places.


May 10, 2011 at 10:37 PM

The list "Service Change Request/Notice (SCR or SCN)" has Content Approval turned on.   Item level permissions are set with Users can read all items, and any user can see draft items.

I'm starting to think my issues has to do with the Content Approval setting.

May 10, 2011 at 10:46 PM

It's got to be permissioning on some level.

I just checked again, and that listName causes no issue for me in WSS 3.0.