Whats wrong with my query

Question

var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml('<Where><Eq><FieldRef Name="IsActive"/><Value Type="Integer">1</Value></Eq></Where><OrderBy><FieldRef Name="SortOrder"/></OrderBy>');
this.collListItem = oList.getItems(camlQuery);

clientContext.load(collListItem);

IsActive is a yes/No where I want it to return only the Yes valuesand I want it ordered by sortOrder in ascending order

Answer 1

Try wrap in "<View><Query> ... </Query></View>"

var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml('<View><Query><Where><Eq><FieldRef Name="IsActive"/><Value Type="Integer">1</Value></Eq></Where><OrderBy><FieldRef Name="SortOrder"/></OrderBy></Query></View>');
this.collListItem = oList.getItems(camlQuery);

clientContext.load(collListItem);