Represents a query field.

Object Model

Syntax

Visual Basic (Declaration)
Public NotInheritable Class QueryFieldBuilder Inherits SimpleFieldBuilder

C#
public sealed class QueryFieldBuilder : SimpleFieldBuilder

Remarks

This class represents a mutable query field object. Query fields used in the schema fields expressions.

Most of the methods that modify an instance of this class return a reference to that same instance. Since a reference to the instance is returned, you can call a method or property on the reference. This can be convenient if you want to write a single statement that chains successive operations one after another.

Example

The following code demonstrates how to create and modify the QueryFieldBuilder instance:

C#	Copy Code
// Create query field 'OrderDate_Year' QueryFieldBuilder queryField = new QueryFieldBuilder("OrderDate_Year"); // Set expression queryField.Expression = new ExpressionBuilder("=Year(Fields!OrderDate.Value)", typeof (int)); SchemaBuilder sb = new SchemaBuilder("MySchema").SetCaption("My Schema"); sb.AddQueryFields( new QueryFieldBuilder("field1"), // Corresponds to the field1 field. "field2", // Implicit conversion. Corresponds to the field2 field. new QueryFieldBuilder("field3").SetExpression<DateTime>("=DateTime(...)"), // Calculated field. queryField );

Copy Code

// Create query field 'OrderDate_Year'
QueryFieldBuilder queryField = new QueryFieldBuilder("OrderDate_Year");
// Set expression
queryField.Expression = new ExpressionBuilder("=Year(Fields!OrderDate.Value)", typeof (int));
            
SchemaBuilder sb = new SchemaBuilder("MySchema").SetCaption("My Schema");
sb.AddQueryFields(
    new QueryFieldBuilder("field1"), // Corresponds to the field1 field.
    "field2", // Implicit conversion. Corresponds to the field2 field.
    new QueryFieldBuilder("field3").SetExpression<DateTime>("=DateTime(...)"), // Calculated field.
    queryField
);

Inheritance Hierarchy

System.Object
GrapeCity.ActiveAnalysis.Schema.SimpleFieldBuilder
GrapeCity.ActiveAnalysis.Schema.QueryFieldBuilder

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2