ColumnRelation Class TIBCO Spotfire 7.6 API Reference
This class describes an equality relation between two columns in different tables. A relation like '[Tbl1].[Column1] = Upper([Tbl2].[Column1])' is defined using two expressions '[Tbl1].[Column1]' and 'Upper([Tbl2].[Column1])'. These expressions are evaluated in the different source tables, so if one of the tables are external then you can use the methods provided by that external data source and if the table is not external then you can use the standard Spotfire expression language functions. Additionally you can also provide left and right transform expressions which are evaluated on top of the left/right expressions supporting all standard Spotfire expression language functions. These expression refer to the result of the corresponding expression using the name ValueColumnName. For example you need to perform "Upper" on Tbl2 but the external system doesn't support that method you can define left and right expressions like '[Tbl1].[Column1]' and '[Tbl2].[Column1]' but add additional transform expressions like '[Value]' and 'Upper([Value])'.
Inheritance Hierarchy

SystemObject
  Spotfire.Dxp.DataColumnRelation

Namespace: Spotfire.Dxp.Data
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 25.11.10401.3615 (25.11.10401.3615)
Syntax

C#
[ImmutableAttribute]
public sealed class ColumnRelation

The ColumnRelation type exposes the following members.

Constructors

  NameDescription
Public methodColumnRelation(String, String)
Initializes a new instance of the ColumnRelation class.
Public methodColumnRelation(String, String, String, String)
Initializes a new instance of the ColumnRelation class.
Top
Methods

  NameDescription
Public methodEquals(Object)
Determines whether the specified Object is equal to the current Object.
(Overrides ObjectEquals(Object).)
Public methodEquals(ColumnRelation)
Will evaluate if the descriptors are the same. The descriptors are considered equal even if the order of the expressions (left/right) are reversed.
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Overrides ObjectGetHashCode.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Top
Properties

  NameDescription
Public propertyLeftTableName
Gets the name of the left table.
Public propertyRightTableName
Gets the name of the right table.
Public propertyStatic memberValueColumnName
Gets the name of the value column used for transforming the data.
Top
Version Information

Supported in: 7.6, 7.5, 7.0, 6.5, 6.0, 5.5
See Also

Reference