Documentation

Creatio development guide
PDF
This documentation is valid for Creatio version 7.16.0. We recommend using the newest version of Creatio documentation.

The EntitySchemaQueryFunction class

Glossary Item Box

Introduction

The Terrasoft.Core.Entities.EntitySchemaQueryFunction class implements the expression function.

The expression function is implemented in the following classes:

  • EntitySchemaQueryFunction – the base class of expression of the entity schema query.
  • EntitySchemaAggregationQueryFunction – implements the aggregate function of the expression.
  • EntitySchemaIsNullQueryFunction – replaces null values with the replacement expression.
  • EntitySchemaCoalesceQueryFunction – returns the first not null expression from the list of arguments.
  • EntitySchemaCaseNotNullQueryFunctionWhenItem – class that describes the condition expression of the CASE SQL operator.
  • EntitySchemaCaseNotNullQueryFunctionWhenItems – collection of condition expressions of the CASE SQL operator.
  • EntitySchemaCaseNotNullQueryFunction – returns one value from the set of possible values depending on the specified conditions.
  • EntitySchemaSystemValueQueryFunction – returns the expression of the system value.
  • EntitySchemaCurrentDateTimeQueryFunction – implements the function for current date and time expression.
  • EntitySchemaBaseCurrentDateQueryFunction – base class of the expression function for the base date.
  • EntitySchemaCurrentDateQueryFunction – implements the function for current date and time expression.
  • EntitySchemaDateToCurrentYearQueryFunction – implements the function that converts the date expression to the same date of the current year.
  • EntitySchemaBaseCurrentDateTimeQueryFunction – implements the function for current date and time expression.
  • EntitySchemaDatePartQueryFunction – implements the function for the datepart of the Date/Time type.
  • EntitySchemaCastQueryFunction – casts the argument expression to the specified data type.
  • EntitySchemaUpperQueryFunction – converts the argument expression characters to uppercase.
  • EntitySchemaTrimQueryFunction – removes whitespaces from both ends of the expression.
  • EntitySchemaLengthQueryFunction – returns the length of the expression.
  • EntitySchemaConcatQueryFunction – returns a string resulting from merging the string arguments of the function.
  • EntitySchemaWindowQueryFunction – implements an SQL window function.

The “Terrasoft.Core.Entities.EntitySchemaQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, parent classes, and implemented interfaces of the EntitySchemaQueryFunction class.

Methods

Table 1. Primary methods of the EntitySchemaQueryFunction class

public abstract QueryColumnExpression CreateQueryColumnExpression((DBSecurityEngine dbSecurityEngine))

For the current function, gets the query column expression that is generated taking into account the specified access rights.

Parameters:

  • dbSecurityEngine – a Terrasoft.Core.DB.DBSecurityEngine object that defines access rights.
public abstract DataValueType GetResultDataValueType((DataValueTypeManager dataValueTypeManager))

Gets the data type of the output returned by the function, using the passed-in data type manager.

Parameters:

  • dataValueTypeManager – data type manager.
public abstract bool GetIsSupportedDataValueType((DataValueType dataValueType))

Indicates whether the output of the function has the specified data type.

Parameters:

  • dataValueType – the type of data.
public abstract string GetCaption(())

Gets the caption of the expression function.

public virtual EntitySchemaQueryExpressionCollection GetArguments(())

Gets the collection of expressions of function arguments.

public void CheckIsSupportedDataValueType((DataValueType dataValueType))

Verifies that the output of the function has the specified data type. Otherwise, an exception is thrown.

Parameters:

  • dataValueType – the type of data.
The “Terrasoft.Core.Entities.EntitySchemaAggregationQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaAggregationQueryFunction class.

Constructors

EntitySchemaAggregationQueryFunction((EntitySchemaQuery parentQuery))

Initializes the EntitySchemaAggregationQueryFunction instance of the specified aggregate function type for the specified query to the object schema.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaAggregationQueryFunction((AggregationTypeStrict aggregationType, EntitySchemaQuery parentQuery))

Initializes the EntitySchemaAggregationQueryFunction instance of the specified aggregate function type for the specified query to the object schema.

Parameters:

  • aggregationType – the type of aggregating function;
  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaAggregationQueryFunction((AggregationTypeStrict aggregationType, EntitySchemaQueryExpression expression, EntitySchemaQuery parentQuery))

Initializes a new EntitySchemaAggregationQueryFunction instance for the specified type of aggregate /// function, expression, and query to the object schema.

Parameters:

  • aggregationType – the type of aggregating function;
  • expression – a query expression;
  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaAggregationQueryFunction((EntitySchemaAggregationQueryFunction source))

Initializes a new EntitySchemaAggregationQueryFunction instance that is a clone of the passed aggregate expression function instance.

Parameters:

  • source – instance of the expression aggregate function whose clone is being created.

Properties

Table 2. Primary properties of the EntitySchemaAggregationQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

AggregationType
AggregationTypeStrict

The type of aggregating function.

AggregationEvalType
AggregationEvalType

The scope of the aggregate function.

Expression
EntitySchemaQueryExpression

The expression of the aggregate function argument.

Methods

Table 3. Primary methods of the EntitySchemaAggregationQueryFunction class

override void WriteMetaData((DataWriter writer))

Serializes the aggregate function, using the specified Terrasoft.Common.DataWriter instance.

Parameters:

  • writer – the Terrasoft.Common.DataWriter instance used for serialization.
override QueryColumnExpression CreateQueryColumnExpression((DBSecurityEngine dbSecurityEngine))

For the aggregate function, gets the query column expression that is generated taking into account the specified access rights.

Parameters:

  • dbSecurityEngine – a Terrasoft.Core.DB.DBSecurityEngine object that defines access rights.
override EntitySchemaQueryExpressionCollection GetArguments(())

Gets the collection of expressions of the aggregate function arguments.

override DataValueType GetResultDataValueType((DataValueTypeManager dataValueTypeManager))

Gets the data type of the output returned by the aggregate function, using the specified data type manager.

Parameters:

  • dataValueTypeManager – data type manager.
override bool GetIsSupportedDataValueType((DataValueType dataValueType))

Indicates whether the output of the aggregate function has the specified data type.

Parameters:

  • dataValueType – the type of data.
override string GetCaption(())

Gets the caption of the expression function.

override object Clone(())

Creates a clone of the current EntitySchemaAggregationQueryFunction instance.

EntitySchemaAggregationQueryFunction All(())

Sets the [To All Values] scope for the current aggregate function.

EntitySchemaAggregationQueryFunction Distinct(())

Sets the [To Unique Values] scope for the current aggregate function.

The “Terrasoft.Core.Entities.EntitySchemaIsNullQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaIsNullQueryFunction class.

Constructors

EntitySchemaIsNullQueryFunction((EntitySchemaQuery parentQuery))

Initializes the EntitySchemaIsNullQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaIsNullQueryFunction((EntitySchemaQuery parentQuery, EntitySchemaQueryExpression checkExpression, EntitySchemaQueryExpression replacementExpression))

Initializes a new EntitySchemaIsNullQueryFunction instance for the specified query to the object schema, validated expression and substitute expression.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function;
  • checkExpression – the expression to check for being null;
  • replacementExpression – the expression returned by the function if checkExpression is null.
EntitySchemaIsNullQueryFunction((EntitySchemaIsNullQueryFunction source))

Initializes a new EntitySchemaIsNullQueryFunction instance that is a clone of the passed expression function.

Parameters:

  • source – an instance of the EntitySchemaIsNullQueryFunction whose clone is being created.

Properties

Table 4 Primary properties of the EntitySchemaIsNullQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

CheckExpression
EntitySchemaQueryExpression

Expression of the function argument to check for being equal to the null value.

ReplacementExpression
EntitySchemaQueryExpression

Expression of the function argument that is returned if the check expression is equal to null.

Methods

Table 5. Primary methods of the EntitySchemaIsNullQueryFunction class

override void WriteMetaData((DataWriter writer))

Serializes the expression function, using the passed DataWriter instance.

Parameters:

  • writer – the DataWriter instance used for serializing the expression function.
override QueryColumnExpression CreateQueryColumnExpression((DBSecurityEngine dbSecurityEngine))

For the current function, gets the query column expression that is generated taking into account the specified access rights.

Parameters:

  • dbSecurityEngine – a Terrasoft.Core.DB.DBSecurityEngine object that defines the access rights.
override EntitySchemaQueryExpressionCollection GetArguments(())

Gets the collection of expressions of function arguments.

override DataValueType GetResultDataValueType((DataValueTypeManager dataValueTypeManager))

Gets the data type of the output returned by the function, using the passed-in data type manager.

Parameters:

  • dataValueTypeManager – data type manager.

The “Terrasoft.Core.Entities.EntitySchemaCoalesceQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaCoalesceQueryFunction class.

Constructors

EntitySchemaCoalesceQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaCoalesceQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaCoalesceQueryFunction((EntitySchemaCoalesceQueryFunction source))

Initializes a new EntitySchemaCoalesceQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaCoalesceQueryFunction whose clone is being created.

Properties

Table 6. Primary properties of the EntitySchemaCoalesceQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

Expressions
EntitySchemaQueryExpressionCollection

Collection of expressions of function arguments.

HasExpressions
bool

Indicates whether at least one item exists in the collection of expressions of the function arguments.

Methods

Table 7. Primary methods of the EntitySchemaCoalesceQueryFunction class

override bool GetIsSupportedDataValueType((DataValueType dataValueType))

Indicates whether the output of the function has the specified data type.

Parameters:

  • dataValueType – the type of data.

The “Terrasoft.Core.Entities.EntitySchemaCaseNotNullQueryFunctionWhenItem” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, parent classes, and implemented interfaces of the EntitySchemaCaseNotNullQueryFunctionWhenItem class.

Constructors

EntitySchemaCaseNotNullQueryFunctionWhenItem(())

Initializes a new instance of the EntitySchemaCaseNotNullQueryFunctionWhenItem class.

EntitySchemaCaseNotNullQueryFunctionWhenItem((EntitySchemaQueryExpression whenExpression, EntitySchemaQueryExpression thenExpression))

Initializes the EntitySchemaCaseNotNullQueryFunctionWhenItem instance for the specified expressions of the WHEN and THEN clauses.

Parameters:

  • whenExpression – expression of the WHEN condition clause;
  • thenExpression – expression of the THEN condition clause.
EntitySchemaCaseNotNullQueryFunctionWhenItem((EntitySchemaCaseNotNullQueryFunctionWhenItem source))

Initializes the EntitySchemaCaseNotNullQueryFunctionWhenItem instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaCaseNotNullQueryFunctionWhenItem whose clone is being created.

Properties

Table 8. Primary properties of the EntitySchemaCaseNotNullQueryFunctionWhenItem class

WhenExpression
EntitySchemaQueryExpression

Expression of the WHEN clause.

ThenExpression
EntitySchemaQueryExpression

Expression of the THEN clause.

The “Terrasoft.Core.Entities.EntitySchemaCaseNotNullQueryFunctionWhenItems” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, parent classes, and implemented interfaces of the EntitySchemaCaseNotNullQueryFunctionWhenItems class.

Constructors

EntitySchemaCaseNotNullQueryFunctionWhenItems(())

Initializes an EntitySchemaCaseNotNullQueryFunctionWhenItems instance.

EntitySchemaCaseNotNullQueryFunctionWhenItems((EntitySchemaCaseNotNullQueryFunctionWhenItems source))

Initializes a new EntitySchemaCaseNotNullQueryFunctionWhenItems instance that is a clone of the passed collection of conditions.

Parameters:

  • source – the collection of conditions whose clone is being created.

The “Terrasoft.Core.Entities.EntitySchemaCaseNotNullQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaCaseNotNullQueryFunction class.

Constructors

EntitySchemaCaseNotNullQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaCaseNotNullQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaCaseNotNullQueryFunction((EntitySchemaCaseNotNullQueryFunction source))

Initializes a new EntitySchemaCaseNotNullQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaCaseNotNullQueryFunction whose clone is being created.

Properties

Table 9. Primary properties of the EntitySchemaCaseNotNullQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

WhenItems
EntitySchemaCaseNotNullQueryFunctionWhenItems

Collection of conditions of the expression function.

HasWhenItems
bool

Indicates whether the function has at least one condition.

ElseExpression
EntitySchemaQueryExpression

Expression of the ELSE clause.

Methods

Table 10. Primary methods of the EntitySchemaCaseNotNullQueryFunction class

void SpecifyQueryAlias((string queryAlias))

For the current expression function, defines the specified alias in the resulting SQL query.

Parameters:

  • queryAlias – alias to define for the current function.

The “Terrasoft.Core.Entities.EntitySchemaSystemValueQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaSystemValueQueryFunction class.

Properties

Table 11. Primary properties of the EntitySchemaSystemValueQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

SystemValueName
string

Name of the system value.

The “Terrasoft.Core.Entities.EntitySchemaBaseCurrentDateQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaBaseCurrentDateQueryFunction class.

Properties

Table 12. Primary properties of the EntitySchemaBaseCurrentDateQueryFunction class

SystemValueName
string

Name of the system value.

Offset
int

The offset.

The “Terrasoft.Core.Entities.EntitySchemaDateToCurrentYearQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaDateToCurrentYearQueryFunction class.

Constructors

EntitySchemaDateToCurrentYearQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaDateToCurrentYearQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
ntitySchemaDateToCurrentYearQueryFunction((EntitySchemaQuery parentQuery, EntitySchemaQueryExpression expression))

Initializes the new EntitySchemaDateToCurrentYearQueryFunction instance for the specified entity schema query and passed date expression.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function;
  • expression – a query expression.
EntitySchemaDateToCurrentYearQueryFunction((EntitySchemaDateToCurrentYearQueryFunction source))

Initializes a new EntitySchemaDateToCurrentYearQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaDateToCurrentYearQueryFunction whose clone is being created.

Properties

Table 13. Primary properties of the EntitySchemaDateToCurrentYearQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

Expression
EntitySchemaQueryExpression

The expression of the function arguments.

The “Terrasoft.Core.Entities.EntitySchemaCurrentTimeQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaCurrentTimeQueryFunction class.

Constructors

EntitySchemaCurrentTimeQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaCurrentTimeQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaCurrentTimeQueryFunction((EntitySchemaCurrentTimeQueryFunction source))

Initializes a new EntitySchemaCurrentTimeQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaCurrentTimeQueryFunction whose clone is being created.

Properties

Table 14. Primary properties of the EntitySchemaCurrentTimeQueryFunction class

SystemValueName
string

Name of the system value.

The “Terrasoft.Core.Entities.EntitySchemaCurrentUserQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaCurrentUserQueryFunction class.

Constructors

EntitySchemaCurrentUserQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaCurrentUserQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaCurrentUserQueryFunction((EntitySchemaCurrentUserQueryFunction source))

Initializes a new EntitySchemaCurrentUserQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaCurrentUserQueryFunction whose clone is being created.

Properties

Table 15. Primary properties of the EntitySchemaCurrentUserQueryFunction class

SystemValueName
string

Name of the system value.

The “Terrasoft.Core.Entities.EntitySchemaCurrentUserAccountQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaCurrentUserAccountQueryFunction class.

Constructors

EntitySchemaCurrentUserAccountQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaCurrentUserAccountQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaCurrentUserAccountQueryFunction((EntitySchemaCurrentUserAccountQueryFunction source))

Initializes a new EntitySchemaCurrentUserAccountQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaCurrentUserAccountQueryFunction whose clone is being created.

Properties

Table 16. Primary properties of the EntitySchemaCurrentUserAccountQueryFunction class

SystemValueName
string

Name of the system value.

The “Terrasoft.Core.Entities.EntitySchemaUpperQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaUpperQueryFunction class.

Constructors

EntitySchemaUpperQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaUpperQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaUpperQueryFunction((EntitySchemaQuery parentQuery, EntitySchemaQueryExpression expression))

Initializes the new EntitySchemaUpperQueryFunction instance for the specified entity schema query and passed date expression.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function;
  • expression – a query expression.
EntitySchemaUpperQueryFunction((EntitySchemaUpperQueryFunction source))

Initializes a new EntitySchemaUpperQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaUpperQueryFunction whose clone is being created.

Properties

Table 17. Primary properties of the EntitySchemaUpperQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

Expression
EntitySchemaQueryExpression

The expression of the function arguments.

The “Terrasoft.Core.Entities.EntitySchemaTrimQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaTrimQueryFunction class.

Constructors

EntitySchemaTrimQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaTrimQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaTrimQueryFunction((EntitySchemaQuery parentQuery, EntitySchemaQueryExpression expression))

Initializes the new EntitySchemaTrimQueryFunction instance for the specified entity schema query and passed date expression.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function;
  • expression – a query expression.
EntitySchemaTrimQueryFunction((EntitySchemaTrimQueryFunction source))

Initializes a new EntitySchemaTrimQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaTrimQueryFunction whose clone is being created.

Properties

Table 18. Primary properties of the EntitySchemaTrimQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

Expression
EntitySchemaQueryExpression

The expression of the function arguments.

The “Terrasoft.Core.Entities.EntitySchemaLengthQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaLengthQueryFunction class.

Constructors

EntitySchemaLengthQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaLengthQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaLengthQueryFunction((EntitySchemaQuery parentQuery, EntitySchemaQueryExpression expression))

Initializes the new EntitySchemaLengthQueryFunction instance for the specified entity schema query and passed date expression.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function;
  • expression – a query expression.
EntitySchemaLengthQueryFunction((EntitySchemaLengthQueryFunction source))

Initializes a new EntitySchemaLengthQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaLengthQueryFunction whose clone is being created.

Properties

Table 19. Primary properties of the EntitySchemaLengthQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

Expression
EntitySchemaQueryExpression

The expression of the function arguments.

The “Terrasoft.Core.Entities.EntitySchemaCastQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaCastQueryFunction class.

Constructors

EntitySchemaCastQueryFunction((EntitySchemaQuery parentQuery, DBDataValueType castType))

Initializes a new EntitySchemaCastQueryFunction instance for the specified query to the schema of the object with the specified target data type.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function;
  • castType – the target data type.
EntitySchemaCastQueryFunction((EntitySchemaQuery parentQuery, EntitySchemaQueryExpression expression, DBDataValueType castType))

Initializes a new EntitySchemaCastQueryFunction instance with the specified expression and target data type.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function;
  • expression – a query expression;
  • castType – the target data type.
EntitySchemaCastQueryFunction((EntitySchemaCastQueryFunction source))

Initializes a new EntitySchemaCastQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaCastQueryFunction whose clone is being created.

Properties

Table 20. Primary properties of the EntitySchemaCoalesceQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

Expression
EntitySchemaQueryExpression

The expression of the function argument.

CastType
DBDataValueType

The target data type.

The “Terrasoft.Core.Entities.EntitySchemaConcatQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaConcatQueryFunction class.

Constructors

EntitySchemaConcatQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaConcatQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaConcatQueryFunction((EntitySchemaQuery parentQuery, EntitySchemaQueryExpression[] expressions))

Initializes a new EntitySchemaConcatQueryFunction instance for the specified array of expressions and entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function;
  • expressions – array of expressions.
EntitySchemaConcatQueryFunction((EntitySchemaConcatQueryFunction source))

Initializes a new EntitySchemaConcatQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaConcatQueryFunction whose clone is being created.

Properties

Table 21. Primary properties of the EntitySchemaConcatQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

Expressions
EntitySchemaQueryExpressionCollection

Collection of expressions of function arguments.

HasExpressions
bool

Indicates whether at least one item exists in the collection of expressions of the function arguments.

The “Terrasoft.Core.Entities.EntitySchemaWindowQueryFunction” class

Use the “.NET class libraries of platform core” documentation to access the full list of the methods, properties, parent classes, and implemented interfaces of the EntitySchemaWindowQueryFunction class.

Constructors

EntitySchemaWindowQueryFunction((EntitySchemaQuery parentQuery))

Initializes the new EntitySchemaWindowQueryFunction instance for the specified entity schema query.

Parameters:

  • parentQuery – query against the schema of the entity that contains the function.
EntitySchemaWindowQueryFunction((EntitySchemaQueryExpression function, EntitySchemaQuery esq))

Initializes the new EntitySchemaWindowQueryFunction instance for the specified entity schema query.

Parameters:

  • function – nested query function;
  • esq – the expression of the entity schema query.
EntitySchemaWindowQueryFunction((EntitySchemaQueryExpression function, EntitySchemaQuery esq, EntitySchemaQueryExpression partitionBy = null, EntitySchemaQueryExpression orderBy = null))

Initializes the new EntitySchemaWindowQueryFunction instance for the specified entity schema query.

Parameters:

  • function – nested query function;
  • parentQuery – query against the schema of the entity that contains the function;
  • partitionBy – the expression for splitting the query;
  • orderBy – the expression for sorting the query.
EntitySchemaWindowQueryFunction((EntitySchemaQueryFunction source))

Initializes a new EntitySchemaWindowQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaQueryFunction whose clone is being created.
EntitySchemaWindowQueryFunction((EntitySchemaWindowQueryFunction source))

Initializes a new EntitySchemaWindowQueryFunction instance that is a clone of the passed function.

Parameters:

  • source – the EntitySchemaWindowQueryFunction whose clone is being created.

Properties

Table 22. Primary properties of the EntitySchemaConcatQueryFunction class

QueryAlias
string

The alias of the function in the SQL query.

InnerFunction
EntitySchemaQueryExpression

The function to apply.

PartitionByExpression
EntitySchemaQueryExpression

Split by expression.

OrderByExpression
EntitySchemaQueryExpression

Sort by expression.

© Creatio 2002-2020.

Did you find this information useful?

How can we improve it?