Design Dabbler

SPServices GetListItems query Multiple Columns

Hi All,


Tried to find this issue in other post but I have not been able to get anything. I am trying to use SPservices jquery script lookup valuer across 2 columns, I was hoping someone would be able to assist:


I have a sharepoint list named journal spservices tutorial and i got the query against the Title working no problems. However when it is querying against multiple columns Title and Product. I get empty results:





NWF$(document).ready(function() {
  //The source data for the autocomplete is the Journals list  
  //Store the journal titles in a array variable  
  var externalParties = [];
    operation: "GetListItems",
    async: false,
    listName: "Journals",
    CAMLViewFields: "<ViewFields><FieldRef Name='Title' /><FieldRef Name='Product' /></ViewFields>", //the name needs to be changed accordingly   
    completefunc: function(xData, Status) {
      NWF$(xData.responseXML).SPFilterNode("z:row").each(function() {
  //journalinput is added on the control in the NF  
  NWF$("#" + journalinput).autocomplete({
    source: externalParties


0 Kudos
1 Reply
Design Dabbler

Re: SPServices GetListItems query Multiple Columns

you are missing your string quotes. "[" + $(this).attr("ows_Title") +","+$(this).attr("ows_Product")++"]";

0 Kudos