Active Query Builder 2 .NET Edition reference
OutputColumn Class Members
Properties  Methods 

The following tables list the members exposed by OutputColumn.

Public Properties
 NameDescription
Public PropertyColumnGets the reference to the StatisticsOutputColumn corresponding to this column.  
Public PropertyIsSupportFilteringIndicates if it's possible to add filtration conditions for this column.  
Public PropertyIsSupportSortingIndicates if it's possible to sort by this column.  
Public PropertyNameGets the name of result set column.  
Public PropertyQueryBuilderGets the reference to the QueryBuilder component that contains the initial query.  
Public PropertyQueryTransformerGets the reference to the parent QueryTransformer component that owns and maintains entire columns list.  
Public PropertyVisibleGets or sets the sign of presence of the column in result SQL query.  
Top
Public Methods
 NameDescription
Public MethodAscCreates new sorting item to sort by the column in ascending order. Alias for "Ascending".  
Public MethodAscendingCreates new sorting item to sort by the column in ascending order.  
Public MethodAssignOverridden.   
Public MethodAvgCreates new aggregation item to return the average value of this column in resultset.  
Public MethodBetweenCreates new filter condition for the column to accept values in a range Between the specified.  
Public MethodConditionCreates new filter condition for the column to accept values that meet the specified condition.  
Public MethodCountCreates new aggregation item to count the number of not-null items in resultset.  
Public MethodDescCreates new sorting item to sort by the column in descending order. Alias for "Descending".  
Public MethodDescendingCreates new sorting item to sort by the column in descending order.  
Public MethodEqualCreates new filter condition for the column to accept values that are Equal to the specified.  
Public MethodGreaterCreates new filter condition for the column to accept values that are Greater than the specified.  
Public MethodGreaterEqualCreates new filter condition for the column to accept values that are Greater or Equal to the specified.  
Public MethodInCreates new filter condition for the column to accept values Listed in the specified comma-separated string.  
Public MethodIsNotNullCreates new filter condition to accept Not Null values for the column. Alias for "Not_IsNull".  
Public MethodIsNullCreates new filter condition for the column to accept Null values.  
Public MethodLessCreates new filter condition for the column to accept values that are Less than the specified.  
Public MethodLessEqualCreates new filter condition for the column to accept values that are Less or Equal to the specified.  
Public MethodLikeCreates new filter condition for the column to accept values like the specified pattern.  
Public MethodMaxCreates new aggregation item to return the maximum value of this column in resultset.  
Public MethodMinCreates new aggregation item to return the minimum value of this column in resultset.  
Public MethodNot_BetweenCreates new filter condition for the column to accept values not in a range Between the specified.  
Public MethodNot_EqualCreates new filter condition for the column to accept values that are Not Equal to the specified.  
Public MethodNot_GreaterCreates new filter condition for the column to accept values that are Not Greater than the specified.  
Public MethodNot_GreaterEqualCreates new filter condition for the column to accept values that are Not Greater or Equal than the specified. Alias for "Less".  
Public MethodNot_InCreates new filter condition for the column to accept values Not Listed in the specified comma-separated string.  
Public MethodNot_IsNullCreates new filter condition to accept Not Null values for the column.  
Public MethodNot_LessCreates new filter condition for the column to accept values that are Not Less than the specified.  
Public MethodNot_LessEqualCreates new filter condition for the column to accept values that are Not Less or Equal than the specified. Alias for "Greater".  
Public MethodNot_LikeCreates new filter condition for the column to accept values Not like the specified pattern.  
Public MethodSumCreates new aggregation item to summarize values of this column in resultset.  
Top
See Also

Reference

OutputColumn Class
ActiveDatabaseSoftware.ActiveQueryBuilder.QueryTransformer Namespace

 

 


© Copyright 2005-2012 ActiveDBSoft. All rights reserved.

Send Feedback