static void CAMLQueryWithSubQuery()
{
List<string> status = new List<string>();
status.Add("Status1");
status.Add("Status2");
List<SubQuery> queries = new List<SubQuery>();
foreach (string sta in status)
{
List<FieldQuery> singleQueries = new List<FieldQuery>();
QBField Statusfield = new QBField("LU_Status", sta, FieldType.Lookup);
QBField StatusHiddenfield = new QBField("StatusHidden", sta, FieldType.Text);
FieldQuery sqe1 = new FieldQuery(StatusHiddenfield, OperationType.Neq, OperatorType.And);
FieldQuery sqe = new FieldQuery(Statusfield, OperationType.Eq, OperatorType.And);
singleQueries.Add(sqe1);
singleQueries.Add(sqe);
SubQuery subQuery = new SubQuery(singleQueries, OperatorType.Or);
queries.Add(subQuery);
}
CAMLQuery oCAMLquery = new CAMLQuery(queries, 47, null);
Console.Write(oCAMLquery.ViewExpression);
}
static void CAMLQueryWithSubQueryAndOrderby()
{
List<string> status = new List<string>();
status.Add("Status1");
status.Add("Status2");
List<SubQuery> queries = new List<SubQuery>();
foreach (string sta in status)
{
List<FieldQuery> singleQueries = new List<FieldQuery>();
QBField Statusfield = new QBField("LU_Status", sta, FieldType.Lookup);
QBField StatusHiddenfield = new QBField("StatusHidden", sta, FieldType.Text);
FieldQuery sqe1 = new FieldQuery(StatusHiddenfield, OperationType.Neq, OperatorType.And);
FieldQuery sqe = new FieldQuery(Statusfield, OperationType.Eq, OperatorType.And);
singleQueries.Add(sqe1);
singleQueries.Add(sqe);
SubQuery subQuery = new SubQuery(singleQueries, OperatorType.Or);
queries.Add(subQuery);
}
QBField domainName = new QBField();
domainName.Name = "DomainName";
QBField statusF = new QBField();
statusF.Name = "LU_Status";
List<QBOrderBy> allOrderBy = new List<QBOrderBy>();
allOrderBy.Add(domainName.OrderByExpressionAsc);
allOrderBy.Add(statusF.OrderByExpressionDesc);
OrderByQuery orderByQuery = new OrderByQuery(allOrderBy);
CAMLQuery oCAMLquery = new CAMLQuery(queries, 47, orderByQuery);
Console.Write(oCAMLquery.ViewExpression);
}
