public void ExecuteDummy(Session session)
{
string sql = Properties.Resources.Dummy_Select_Query;
ConditionExpression conditions = new ConditionExpression();
ConditionExpression exp1 = conditions.CreateChild();
ConditionExpression exp2 = conditions.CreateChild();
exp2.Statements.Add(new ConditionStatement(Constants.ConditionType.None,
new ConditionValue(ConditionValueType.AttributeName, "SafetyStockLevel"),
ConditionQualifier.LessThan,
new ConditionValue(ConditionValueType.Constant, 10)));
exp2.Statements.Add(new ConditionStatement(Constants.ConditionType.Or,
new ConditionValue(ConditionValueType.AttributeName, "SafetyStockLevel"), ConditionQualifier.GreaterThan, new ConditionValue(ConditionValueType.Constant, 500)));
exp1.Children.Add(exp2);
exp1.Statements.Add(new ConditionStatement(Constants.ConditionType.And,
new ConditionValue(ConditionValueType.AttributeName, "SafetyStockLevel"), ConditionQualifier.NotEquals, new ConditionValue(ConditionValueType.Constant, 1000)));
ConditionExpression exp3 = conditions.CreateChild(ConditionType.And);
exp3.Statements.Add(new ConditionStatement(Constants.ConditionType.Or,
new ConditionValue(ConditionValueType.AttributeName, "Color"), ConditionQualifier.Equals, new ConditionValue(ConditionValueType.Constant, "Silver")));
exp3.Statements.Add(new ConditionStatement(Constants.ConditionType.Or,
new ConditionValue(ConditionValueType.AttributeName, "Color"), ConditionQualifier.Equals, new ConditionValue(ConditionValueType.Constant, "Black")));
conditions.Statements.Add(new ConditionStatement(Constants.ConditionType.And,
new ConditionValue(ConditionValueType.AttributeName, "FinishedGoodsFlag"), ConditionQualifier.Equals, new ConditionValue(ConditionValueType.Constant, "1")));
var documentIds = _core.Document.GetIdsByCondition(session, "AdventureWorks2008R2:Production:Product", conditions);
/*
* ( <exp1>
* ( <exp2>
* SafetyStockLevel < 10
* OR SafetyStockLevel > 500
* )
* AND SafetyStockLevel <> 1000
* )
* AND ( <exp3>
* Color = 'Silver'
* OR Color = 'Black'
* )
* AND FinishedGoodsFlag = 1
*/
}
