I am trying to fetch the result from list based on 3 conditions( Month Name,Employee,Department).
In my SharePoint List(Month Name is calculated column fetching month from column "Joining Date") .
Below is the caml query trying to get fetech the value using column(Month Name) but found no luck.I had gone through the internal of the column "Month Name" and I see "Month" as internal name
can any one help me in knowing what went wrong in below code
var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml("<View><Query><Where><And><Eq><FieldRef Name='Employee'/><Value Type='Text'>" + Employee + "</Value></Eq><Eq><FieldRef Name='Department'/><Value Type='Text'>" + Department+ "</Value></Eq><Eq><FieldRef Name='Month Name'/><Value Type='Calculated'>" + monthname+ "</Value></Eq></And></Where></Query></View>")
Eqdirectly in one
Andstatement, so you need to add another