Skip to main content
1 of 2
SharePointMan
  • 3.4k
  • 5
  • 33
  • 52

SPservice for filtering Dropdown based on parent dropdown

we are $().SPServices.SPCascadeDropdowns for cascading. Suddenly it stopped working. now I want to use another option of using SPServices with CAML query to display the projects based on Employee selected. Something like this

 $().SPServices({
                     operation: "GetListItems",
                     async: false,
                     listName: "Project Allocation",                    
                     CAMLRowLimit: 1,
                     CAMLQuery: "<Where><Eq><FieldRef Name='Employee' /><Value Type='Lookup'>" + thisUserAccount  + "</Value></Eq></Where>",   
                     CAMLViewFields:"<ViewFields><FieldRef Name='Project' /></ViewFields>"  ,
                     completefunc:null,
                     debug:true
                     });

but I am getting an error while opening the list form.I am new to SPServices. please guide me for this

SharePointMan
  • 3.4k
  • 5
  • 33
  • 52