Skip to main content
deleted 11 characters in body
Source Link
SharePointMan
  • 3.4k
  • 5
  • 33
  • 52

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"<Query><Where><Eq><FieldRef Name='Employee' /><Value Type='Lookup'>" + thisUserAccount  + "</Value></Eq></Where>"Where></Query>",   
                     CAMLViewFields:"<ViewFields><FieldRef Name='Project' /></ViewFields>"  ,
                     completefunc:null,
                     debug:true
                     });

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

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

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: "<Query><Where><Eq><FieldRef Name='Employee' /><Value Type='Lookup'>" + thisUserAccount  + "</Value></Eq></Where></Query>",   
                     CAMLViewFields:"<ViewFields><FieldRef Name='Project' /></ViewFields>"  ,
                     completefunc:null,
                     debug:true
                     });

but I am not able to filter.I am new to SPServices. please guide me for this

Source Link
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