Class DataQuerySettings

Namespace

CMS.DataEngine

Assembly

CMS.DataEngine.dll

Defines parameters for the data query. Use DataQuery method UseParameters to apply this parameters to a query.

public class DataQuerySettings : DataQuerySettingsBase<DataQuerySettings>, IDataQuerySettings<DataQuerySettings>, IWhereCondition<DataQuerySettings>, IQueryParameters<DataQuerySettings>, IDataQuerySettings, IWhereCondition, IQueryParameters, IQueryObject

Inheritance

object

AbstractQueryObject

QueryParametersBase<DataQuerySettings>

WhereConditionBase<DataQuerySettings>

DataQuerySettingsBase<DataQuerySettings>

DataQuerySettings

Implements

IDataQuerySettings<DataQuerySettings>

IWhereCondition<DataQuerySettings>

IQueryParameters<DataQuerySettings>

IDataQuerySettings

IWhereCondition

IQueryParameters

IQueryObject

Inherited Members

DataQuerySettingsBase<DataQuerySettings>.mOrderByColumns

DataQuerySettingsBase<DataQuerySettings>.mSelectColumnsList

DataQuerySettingsBase<DataQuerySettings>.mOffset

DataQuerySettingsBase<DataQuerySettings>.mMaxRecords

DataQuerySettingsBase<DataQuerySettings>.OrderByColumns

DataQuerySettingsBase<DataQuerySettings>.FilterColumns

DataQuerySettingsBase<DataQuerySettings>.SelectColumnsList

DataQuerySettingsBase<DataQuerySettings>.GroupByColumns

DataQuerySettingsBase<DataQuerySettings>.HavingCondition

DataQuerySettingsBase<DataQuerySettings>.TopNRecords

DataQuerySettingsBase<DataQuerySettings>.QuerySource

DataQuerySettingsBase<DataQuerySettings>.SelectDistinct

DataQuerySettingsBase<DataQuerySettings>.DefaultQuerySource

DataQuerySettingsBase<DataQuerySettings>.Offset

DataQuerySettingsBase<DataQuerySettings>.MaxRecords

DataQuerySettingsBase<DataQuerySettings>.TotalExpression

DataQuerySettingsBase<DataQuerySettings>.GetTotalRecordsForPagedQuery

DataQuerySettingsBase<DataQuerySettings>.IsPagedQuery

DataQuerySettingsBase<DataQuerySettings>.IsSubQuery

DataQuerySettingsBase<DataQuerySettings>.IsNested

DataQuerySettingsBase<DataQuerySettings>.HavingIsComplex

DataQuerySettingsBase<DataQuerySettings>.HavingIsEmpty

DataQuerySettingsBase<DataQuerySettings>.HasGroupBy

DataQuerySettingsBase<DataQuerySettings>.GetDefaultSource()

DataQuerySettingsBase<DataQuerySettings>.ApplyParametersTo(IQueryObject)

DataQuerySettingsBase<DataQuerySettings>.CopyPropertiesTo(IQueryObject)

DataQuerySettingsBase<DataQuerySettings>.GetExpressions(QueryDataParameters)

DataQuerySettingsBase<DataQuerySettings>.AnySettingsDefined()

DataQuerySettingsBase<DataQuerySettings>.ReplaceSelectedColumn(string, string)

DataQuerySettingsBase<DataQuerySettings>.ReplaceOrderByColumn(string, string)

DataQuerySettingsBase<DataQuerySettings>.ToString(bool)

DataQuerySettingsBase<DataQuerySettings>.AddHavingInternal(IWhereCondition)

DataQuerySettingsBase<DataQuerySettings>.Then()

DataQuerySettingsBase<DataQuerySettings>.Take()

DataQuerySettingsBase<DataQuerySettings>.Distinct(bool)

DataQuerySettingsBase<DataQuerySettings>.TopN(int)

DataQuerySettingsBase<DataQuerySettings>.Column(string)

DataQuerySettingsBase<DataQuerySettings>.Column(IQueryColumn)

DataQuerySettingsBase<DataQuerySettings>.Columns(IEnumerable<string>)

DataQuerySettingsBase<DataQuerySettings>.Columns(params string[])

DataQuerySettingsBase<DataQuerySettings>.Columns(params IQueryColumn[])

DataQuerySettingsBase<DataQuerySettings>.AddColumn(IQueryColumn)

DataQuerySettingsBase<DataQuerySettings>.AddColumns(params IQueryColumn[])

DataQuerySettingsBase<DataQuerySettings>.AddColumn(string)

DataQuerySettingsBase<DataQuerySettings>.AddColumns(IEnumerable<string>)

DataQuerySettingsBase<DataQuerySettings>.AddColumns(params string[])

DataQuerySettingsBase<DataQuerySettings>.AddFilterColumn(IQueryColumn)

DataQuerySettingsBase<DataQuerySettings>.NoColumns()

DataQuerySettingsBase<DataQuerySettings>.ReplaceColumn(string, string)

DataQuerySettingsBase<DataQuerySettings>.Page(int, int)

DataQuerySettingsBase<DataQuerySettings>.PagedBy(int)

DataQuerySettingsBase<DataQuerySettings>.NotPaged()

DataQuerySettingsBase<DataQuerySettings>.NextPage()

DataQuerySettingsBase<DataQuerySettings>.OrderBy(params string[])

DataQuerySettingsBase<DataQuerySettings>.OrderByDescending(params string[])

DataQuerySettingsBase<DataQuerySettings>.OrderByAscending(params string[])

DataQuerySettingsBase<DataQuerySettings>.OrderBy(OrderDirection, params string[])

DataQuerySettingsBase<DataQuerySettings>.NewGroupBy(params string[])

DataQuerySettingsBase<DataQuerySettings>.GroupBy(params string[])

DataQuerySettingsBase<DataQuerySettings>.NewHaving()

DataQuerySettingsBase<DataQuerySettings>.Having(string, bool)

DataQuerySettingsBase<DataQuerySettings>.Having(params IWhereCondition[])

DataQuerySettingsBase<DataQuerySettings>.Having(Action<WhereCondition>)

WhereConditionBase<DataQuerySettings>.WhereOperator

WhereConditionBase<DataQuerySettings>.WhereCondition

WhereConditionBase<DataQuerySettings>.WhereIsComplex

WhereConditionBase<DataQuerySettings>.WhereIsEmpty

WhereConditionBase<DataQuerySettings>.ReturnsNoResults

WhereConditionBase<DataQuerySettings>.DataSourceName

WhereConditionBase<DataQuerySettings>.ResetWhereOperator()

WhereConditionBase<DataQuerySettings>.GetWhere(IQueryObjectWithValue, QueryOperator, object)

WhereConditionBase<DataQuerySettings>.GetWhere(string, QueryOperator, object)

WhereConditionBase<DataQuerySettings>.AddWhereConditionInternal(IWhereCondition, bool)

WhereConditionBase<DataQuerySettings>.GetContainsPattern(string)

WhereConditionBase<DataQuerySettings>.GetDataSourceName()

WhereConditionBase<DataQuerySettings>.And()

WhereConditionBase<DataQuerySettings>.And(IWhereCondition)

WhereConditionBase<DataQuerySettings>.And(Action<WhereCondition>)

WhereConditionBase<DataQuerySettings>.Or()

WhereConditionBase<DataQuerySettings>.Or(IWhereCondition)

WhereConditionBase<DataQuerySettings>.Or(Action<WhereCondition>)

WhereConditionBase<DataQuerySettings>.AddWhereCondition(string)

WhereConditionBase<DataQuerySettings>.WhereNotNull(IQueryObjectWithValue)

WhereConditionBase<DataQuerySettings>.WhereNotNull(string)

WhereConditionBase<DataQuerySettings>.WhereEmpty(string)

WhereConditionBase<DataQuerySettings>.WhereNotEmpty(string)

WhereConditionBase<DataQuerySettings>.WhereNull(IQueryObjectWithValue)

WhereConditionBase<DataQuerySettings>.WhereNull(string)

WhereConditionBase<DataQuerySettings>.WhereTrue(IQueryObjectWithValue)

WhereConditionBase<DataQuerySettings>.WhereTrue(string)

WhereConditionBase<DataQuerySettings>.WhereFalse(IQueryObjectWithValue)

WhereConditionBase<DataQuerySettings>.WhereFalse(string)

WhereConditionBase<DataQuerySettings>.WhereIn(string, IDataQuery)

WhereConditionBase<DataQuerySettings>.WhereNotIn(string, IDataQuery)

WhereConditionBase<DataQuerySettings>.WhereIn(string, IDataQuery, bool)

WhereConditionBase<DataQuerySettings>.HasCompatibleSource(IDataQuery)

WhereConditionBase<DataQuerySettings>.WhereIn(string, ICollection<int>)

WhereConditionBase<DataQuerySettings>.WhereIn(string, IEnumerable<int>)

WhereConditionBase<DataQuerySettings>.WhereIn(string, ICollection<string>)

WhereConditionBase<DataQuerySettings>.WhereIn(string, IEnumerable<string>)

WhereConditionBase<DataQuerySettings>.WhereIn(string, ICollection<long>)

WhereConditionBase<DataQuerySettings>.WhereIn(string, IEnumerable<long>)

WhereConditionBase<DataQuerySettings>.WhereIn(string, ICollection<Guid>)

WhereConditionBase<DataQuerySettings>.WhereIn(string, IEnumerable<Guid>)

WhereConditionBase<DataQuerySettings>.WhereNotIn(string, ICollection<int>)

WhereConditionBase<DataQuerySettings>.WhereNotIn(string, ICollection<string>)

WhereConditionBase<DataQuerySettings>.WhereNotIn(string, ICollection<long>)

WhereConditionBase<DataQuerySettings>.WhereNotIn(string, ICollection<Guid>)

WhereConditionBase<DataQuerySettings>.WhereNotIn(string, IEnumerable<int>)

WhereConditionBase<DataQuerySettings>.WhereNotIn(string, IEnumerable<string>)

WhereConditionBase<DataQuerySettings>.WhereNotIn(string, IEnumerable<long>)

WhereConditionBase<DataQuerySettings>.WhereNotIn(string, IEnumerable<Guid>)

WhereConditionBase<DataQuerySettings>.WhereIn(string, ICollection<int>, bool)

WhereConditionBase<DataQuerySettings>.WhereIn(string, ICollection<long>, bool)

WhereConditionBase<DataQuerySettings>.WhereIn(string, ICollection<string>, bool)

WhereConditionBase<DataQuerySettings>.WhereIn(string, ICollection<Guid>, bool)

WhereConditionBase<DataQuerySettings>.WhereIn(string, IEnumerable<int>, bool)

WhereConditionBase<DataQuerySettings>.WhereIn(string, IEnumerable<long>, bool)

WhereConditionBase<DataQuerySettings>.WhereIn(string, IEnumerable<string>, bool)

WhereConditionBase<DataQuerySettings>.WhereIn(string, IEnumerable<Guid>, bool)

WhereConditionBase<DataQuerySettings>.WhereExists(IDataQuery)

WhereConditionBase<DataQuerySettings>.WhereNotExists(IDataQuery)

WhereConditionBase<DataQuerySettings>.WhereExists(IDataQuery, bool)

WhereConditionBase<DataQuerySettings>.Where(params IWhereCondition[])

WhereConditionBase<DataQuerySettings>.WhereNot(IWhereCondition)

WhereConditionBase<DataQuerySettings>.Where(Action<WhereCondition>)

WhereConditionBase<DataQuerySettings>.NewWhere()

WhereConditionBase<DataQuerySettings>.NoResults()

WhereConditionBase<DataQuerySettings>.Where(string, QueryDataParameters)

WhereConditionBase<DataQuerySettings>.WhereContains(IQueryObjectWithValue, string)

WhereConditionBase<DataQuerySettings>.WhereContains(string, string)

WhereConditionBase<DataQuerySettings>.WhereNotContains(IQueryObjectWithValue, string)

WhereConditionBase<DataQuerySettings>.WhereNotContains(string, string)

WhereConditionBase<DataQuerySettings>.WhereStartsWith(IQueryObjectWithValue, string)

WhereConditionBase<DataQuerySettings>.WhereStartsWith(string, string)

WhereConditionBase<DataQuerySettings>.WhereNotStartsWith(IQueryObjectWithValue, string)

WhereConditionBase<DataQuerySettings>.WhereNotStartsWith(string, string)

WhereConditionBase<DataQuerySettings>.WhereEndsWith(IQueryObjectWithValue, string)

WhereConditionBase<DataQuerySettings>.WhereEndsWith(string, string)

WhereConditionBase<DataQuerySettings>.WhereNotEndsWith(IQueryObjectWithValue, string)

WhereConditionBase<DataQuerySettings>.WhereNotEndsWith(string, string)

WhereConditionBase<DataQuerySettings>.Where(IQueryObjectWithValue, QueryOperator, object)

WhereConditionBase<DataQuerySettings>.Where(string, QueryOperator, object)

WhereConditionBase<DataQuerySettings>.Where(IQueryObjectWithValue, QueryUnaryOperator)

WhereConditionBase<DataQuerySettings>.Where(string, QueryUnaryOperator)

WhereConditionBase<DataQuerySettings>.WhereEqualsOrNull(string, object)

WhereConditionBase<DataQuerySettings>.WhereEquals(IQueryObjectWithValue, object)

WhereConditionBase<DataQuerySettings>.WhereEquals(string, object)

WhereConditionBase<DataQuerySettings>.WhereNotEquals(IQueryObjectWithValue, object)

WhereConditionBase<DataQuerySettings>.WhereNotEquals(string, object)

WhereConditionBase<DataQuerySettings>.WhereLessThan(IQueryObjectWithValue, object)

WhereConditionBase<DataQuerySettings>.WhereLessOrEquals(IQueryObjectWithValue, object)

WhereConditionBase<DataQuerySettings>.WhereGreaterThan(IQueryObjectWithValue, object)

WhereConditionBase<DataQuerySettings>.WhereGreaterOrEquals(IQueryObjectWithValue, object)

WhereConditionBase<DataQuerySettings>.WhereLessThan(string, object)

WhereConditionBase<DataQuerySettings>.WhereLessOrEquals(string, object)

WhereConditionBase<DataQuerySettings>.WhereGreaterThan(string, object)

WhereConditionBase<DataQuerySettings>.WhereGreaterOrEquals(string, object)

WhereConditionBase<DataQuerySettings>.WhereLike(IQueryObjectWithValue, object)

WhereConditionBase<DataQuerySettings>.WhereLike(string, string)

WhereConditionBase<DataQuerySettings>.WhereNotLike(IQueryObjectWithValue, object)

WhereConditionBase<DataQuerySettings>.WhereNotLike(string, string)

WhereConditionBase<DataQuerySettings>.WhereID(string, int)

WhereConditionBase<DataQuerySettings>.Equals(object)

WhereConditionBase<DataQuerySettings>.Equals(DataQuerySettings)

WhereConditionBase<DataQuerySettings>.GetHashCode()

QueryParametersBase<DataQuerySettings>.mParameters

QueryParametersBase<DataQuerySettings>.IsImmutable

QueryParametersBase<DataQuerySettings>.Parameters

QueryParametersBase<DataQuerySettings>.CloneObject()

QueryParametersBase<DataQuerySettings>.Clone()

QueryParametersBase<DataQuerySettings>.EnsureParameters()

QueryParametersBase<DataQuerySettings>.IncludeDataParameters(QueryDataParameters, string)

QueryParametersBase<DataQuerySettings>.Immutable()

QueryParametersBase<DataQuerySettings>.GetTypedQuery()

QueryParametersBase<DataQuerySettings>.Expand(string)

QueryParametersBase<DataQuerySettings>.ToString()

AbstractQueryObject.Name

AbstractQueryObject.Changed()

AbstractQueryObject.Reset()

Extension Methods

DataExtensions.With<T>(T, Action<T>)

QueryExtensions.AsLiteral<T>(T)

QueryExtensions.AsValue<T>(T, bool)