Lists with null columns not returned when retrieving custom lists with Caml query and Javascript

Question

I am retrieving a list with caml query and Javascript. Everything works fine besides the fact that I have an image column and not all lists have that column populated: Here is a sample query I am using:

<Where>
  <And>         
     <Eq><FieldRef Name='Name' /> <Value Type=’Text’>'name variable+'</Value></Eq>         
     <Eq><FieldRef Name='Address' /> <Value Type=’Text’>'+address variable+'</Value></Eq>
  </And>
</Where>

Assuming I have a title column and not all title fields (columns) are populated, when I try to retrieve my list - the list items without anything in the title is not returned.

listItemInfo += '\nRoom Name: ' + oListItem.get_item('Title')+ ' ' +'Name: ' + oListItem.get_item('Name') + ' ' + 'Address: ' + oListItem.get_item('Address');

document.getElementById('queryResults').innerHTML=listItemInfo.toString();

How can I return list items regardless of if the Title column is populated or not?

Thanks.

Answer 1

If you are using client-side coding to get the list items, I would think you are using a CEWP? If not, it might be easier to do so if you are just working with this one list. Here is the code for you if you decide to give SPServices a try. I use this within a CEWP myself for my list manipulation:

<script type="text/javascript" src="/_layouts/js/jquery-1.11.0.js"></script>
<script type="text/javascript" src="/_layouts/js/jquery.SPServices-2014.01.js"></script>

$().SPServices({
operation: "GetListItems",
async: false,
listName: "My Custom List",
CAMLViewFields: "<ViewFields><FieldRef Name='ID' /><FieldRef Name='Name' /><FieldRef Name='Address' /></ViewFields>",
completefunc: function (xData, Status) {

//Uncomment the alert to see XML printout of your SharePoint nodes.  This will also give you information about the properties of the node.

//alert(xData.responseXML.xml);

 $(xData.responseXML).SPFilterNode("z:row").each(function() {
//This is an example on how to set your list items to variables     
//var item = $(this);
//var id = item.attr("ows_ID"); 


});

}

});

This code will go through each one of your list items. If there is a null value it will return null instead of breaking and returning nothing. You can then use conditional logic to handle the nulls if you like. You can even use SPServices to update the list items that are null with some information of your choosing. I will let you play around with it good luck to ya! I hope this helps you.

Answer 2

CAMLViewFields: "<ViewFields Properties='True' />"

This should also do the trick!