/// <summary>
        /// Used to get the query root element containing the where condition.
        /// </summary>
        /// <param name="isLookupId">Explicitly specify whether the field referenced in the logical test query condition is a look up field.</param>
        /// <returns>The query root element containing a where condition.</returns>
        protected CamlQueryRoot GetCamlQueryRootForWhere(bool isLookupId)
        {
            CamlQueryRoot camlQuery = new CamlQueryRoot();

            // Construct a LogicalTestDefinition based on PTF Configure file.
            LogicalTestDefinition       logicalTest = new LogicalTestDefinition();
            FieldRefDefinitionQueryTest fieldRef    = new FieldRefDefinitionQueryTest();

            fieldRef.Name                 = Common.GetConfigurationPropertyValue("FieldRefWhere_Name", this.Site);
            logicalTest.FieldRef          = fieldRef;
            logicalTest.FieldRef.LookupId = isLookupId.ToString().ToUpper();
            ValueDefinition value = new ValueDefinition();

            value.Type        = Common.GetConfigurationPropertyValue("FieldRefWhere_Type", this.Site);
            value.Text        = new string[] { Common.GetConfigurationPropertyValue("FieldRefWhere_Text", this.Site) };
            logicalTest.Value = value;

            // Use Equal to construct a Where condition.
            camlQuery.Where = new LogicalJoinDefinition();
            camlQuery.Where.ItemsElementName = new ItemsChoiceType1[] { ItemsChoiceType1.Eq };
            camlQuery.Where.Items            = new LogicalTestDefinition[] { logicalTest };

            // Construct an OrderBy element.
            camlQuery.OrderBy                       = new OrderByDefinition();
            camlQuery.OrderBy.FieldRef              = new FieldRefDefinitionOrderBy[1];
            camlQuery.OrderBy.FieldRef[0]           = new FieldRefDefinitionOrderBy();
            camlQuery.OrderBy.FieldRef[0].Ascending = Common.GetConfigurationPropertyValue("FieldRefOrderBy_Ascending", this.Site);
            camlQuery.OrderBy.FieldRef[0].Name      = Common.GetConfigurationPropertyValue("FieldRefOrderBy_Name", this.Site);

            return(camlQuery);
        }
        /// <summary>
        /// Used to get the query root element containing the where condition.
        /// </summary>
        /// <param name="isLookupId">Explicitly specify whether the field referenced in the logical test query condition is a look up field.</param>
        /// <returns>The query root element containing a where condition.</returns>
        protected CamlQueryRoot GetCamlQueryRootForWhere(bool isLookupId)
        {
            CamlQueryRoot camlQuery = new CamlQueryRoot();

            // Construct a LogicalTestDefinition based on PTF Configure file.
            LogicalTestDefinition logicalTest = new LogicalTestDefinition();
            FieldRefDefinitionQueryTest fieldRef = new FieldRefDefinitionQueryTest();
            fieldRef.Name = Common.GetConfigurationPropertyValue("FieldRefWhere_Name", this.Site);
            logicalTest.FieldRef = fieldRef;
            logicalTest.FieldRef.LookupId = isLookupId.ToString().ToUpper();
            ValueDefinition value = new ValueDefinition();
            value.Type = Common.GetConfigurationPropertyValue("FieldRefWhere_Type", this.Site);
            value.Text = new string[] { Common.GetConfigurationPropertyValue("FieldRefWhere_Text", this.Site) };
            logicalTest.Value = value;

            // Use Equal to construct a Where condition.
            camlQuery.Where = new LogicalJoinDefinition();
            camlQuery.Where.ItemsElementName = new ItemsChoiceType1[] { ItemsChoiceType1.Eq };
            camlQuery.Where.Items = new LogicalTestDefinition[] { logicalTest };

            // Construct an OrderBy element.
            camlQuery.OrderBy = new OrderByDefinition();
            camlQuery.OrderBy.FieldRef = new FieldRefDefinitionOrderBy[1];
            camlQuery.OrderBy.FieldRef[0] = new FieldRefDefinitionOrderBy();
            camlQuery.OrderBy.FieldRef[0].Ascending = Common.GetConfigurationPropertyValue("FieldRefOrderBy_Ascending", this.Site);
            camlQuery.OrderBy.FieldRef[0].Name = Common.GetConfigurationPropertyValue("FieldRefOrderBy_Name", this.Site);

            return camlQuery;
        }