/// <summary> /// Used to get the query with GroupBy and OrderBy condition. /// </summary> /// <param name="isCollapse">Indicate whether the result set is collapsed.</param> /// <returns>A constructed query with GroupBy and OrderBy condition.</returns> protected CamlQueryRoot GetCamlQueryRootForGroupBy(bool isCollapse) { CamlQueryRoot camlQuery = new CamlQueryRoot(); GroupByDefinition groupBy = new GroupByDefinition(); FieldRefDefinitionGroupBy fieldRefGroupBy = new FieldRefDefinitionGroupBy(); fieldRefGroupBy.Ascending = Common.GetConfigurationPropertyValue("FieldRefGroupBy_Ascending", this.Site); fieldRefGroupBy.Name = Common.GetConfigurationPropertyValue("FieldRefGroupBy_Name", this.Site); FieldRefDefinitionGroupBy[] fieldRefs = { fieldRefGroupBy }; groupBy.FieldRef = fieldRefs; groupBy.Collapse = isCollapse.ToString(); groupBy.GroupLimit = int.Parse(Common.GetConfigurationPropertyValue("FieldRefGroupBy_RowLimit", this.Site)); camlQuery.GroupBy = groupBy; return(camlQuery); }
/// <summary> /// Used to get the query with GroupBy and OrderBy condition. /// </summary> /// <param name="isCollapse">Indicate whether the result set is collapsed.</param> /// <returns>A constructed query with GroupBy and OrderBy condition.</returns> protected CamlQueryRoot GetCamlQueryRootForGroupBy(bool isCollapse) { CamlQueryRoot camlQuery = new CamlQueryRoot(); GroupByDefinition groupBy = new GroupByDefinition(); FieldRefDefinitionGroupBy fieldRefGroupBy = new FieldRefDefinitionGroupBy(); fieldRefGroupBy.Ascending = Common.GetConfigurationPropertyValue("FieldRefGroupBy_Ascending", this.Site); fieldRefGroupBy.Name = Common.GetConfigurationPropertyValue("FieldRefGroupBy_Name", this.Site); FieldRefDefinitionGroupBy[] fieldRefs = { fieldRefGroupBy }; groupBy.FieldRef = fieldRefs; groupBy.Collapse = isCollapse.ToString(); groupBy.GroupLimit = int.Parse(Common.GetConfigurationPropertyValue("FieldRefGroupBy_RowLimit", this.Site)); camlQuery.GroupBy = groupBy; return camlQuery; }