Ejemplo n.º 1
0
        /// <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);
        }
Ejemplo n.º 2
0
        /// <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;
        }