I need to put this code:
<View>";
<Query>";
<Where>";
<Eq>";
<FieldRef Name='PublicY' />";
<Value Type='Choice'>Yes</Value>";
</Eq>";
</Where>";
</Query>";
</View>";
(I need to retrieve all items if the item has the collumn Public News = Yes..)
In this Query:
for (var i = 0; i < NewsLists.length; i++) {
var soapEnv = "<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'>";
soapEnv += " <soapenv:Body>";
soapEnv += " <GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>";
soapEnv += " <listName>" + NewsLists[i].ListGUID + "</listName>";
soapEnv += " <query>";
soapEnv += " <Query>";
soapEnv += " <OrderBy Override='TRUE'>";
soapEnv += " <FieldRef Name='Created' Ascending='FALSE' />";
soapEnv += " </OrderBy>";
var currentDate = new Date();
currentDate = currentDate.toISOString();
soapEnv += " <Where>";
soapEnv += " <And>";
soapEnv += " <Or>";
soapEnv += " <IsNull>";
soapEnv += " <FieldRef Name='DateTo' />";
soapEnv += " </IsNull>";
soapEnv += " <Leq>";
soapEnv += " <FieldRef Name='DateFrom' />";
soapEnv += " <Value Type='DateTime' IncludeTimeValue='True'>" + currentDate + "</Value>";
soapEnv += " </Leq>";
soapEnv += " </Or>";
soapEnv += " <Or>";
soapEnv += " <IsNull>";
soapEnv += " <FieldRef Name='DateFrom' />";
soapEnv += " </IsNull>";
soapEnv += " <Geq>";
soapEnv += " <FieldRef Name='DateTime' />";
soapEnv += " <Value Type='DateTime' IncludeTimeValue='True'>" + currentDate + "</Value>";
soapEnv += " </Geq>";
soapEnv += " </Or>";
soapEnv += " </And>";
soapEnv += " </Where>";
soapEnv += " </Query>";
soapEnv += " </query>";
soapEnv += " <queryOptions>";
soapEnv += " <QueryOptions>";
soapEnv += " <IncludeMandatoryColumns>TRUE</IncludeMandatoryColumns>";
soapEnv += " </QueryOptions>";
soapEnv += " </queryOptions>";
soapEnv += " <viewFields>";
soapEnv += " <ViewFields>";
soapEnv += " <FieldRef Name='ows_Title'/>";
soapEnv += " <FieldRef Name='Ingress'/>";
soapEnv += " <FieldRef Name='Visning'/>";
soapEnv += " <FieldRef Name='Bild'/>";
soapEnv += " <FieldRef Name='ows_FileLeafRef'/>";
soapEnv += " </ViewFields>";
soapEnv += " </viewFields>";
var rowLimit = MaxAllNews;
soapEnv += " <rowLimit>" + rowLimit + "</rowLimit>";
soapEnv += " </GetListItems>";
soapEnv += " </soapenv:Body>";
soapEnv += "</soapenv:Envelope>";