SPservice for filtering Dropdown based on parent dropdown

Question

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

Answer 1

Your CAMLQuery: "<Where><Eq><FieldRef Name='Employee' /><Value Type='Lookup'>" + thisUserAccount + "</Value></Eq></Where>"

should have "<Query>" tags:

CAMLQuery: "<Query><Where><Eq><FieldRef Name='Employee' /><Value Type='Lookup'>" + thisUserAccount  + "</Value></Eq></Where></Query>"

Answer 2

If the cascade stopped working after a SharePoint upgrade, check out this blog post: http://sympmarc.com/2014/01/23/office-365-update-changes-display-name-on-required-fields/

I would also suggest to try out this solution for Cascading Selects (disclaimer: I am the author).

Answer 3

Try adding LookupId='TRUE' to your FieldRef. (Also make sure that Employee is the internal name of your field.)

<Query><Where><Eq><FieldRef Name='Employee' LookupId='TRUE'/><Value Type='Lookup'>" + thisUserAccount  + "</Value></Eq></Where></Query>

Also, an employee's userID varies depending on what site you're in. It's stored in a hidden list in each site.

userID = $().SPServices.SPGetCurrentUser({
    fieldName: "ID",
    fieldNames: {},
    debug: false
});