Spotfire.Dxp.Data Namespace TIBCO Spotfire 7.6 API Reference
The Spotfire.Dxp.Data namespace contains classes for accessing, transforming and exporting data.
Classes
  Class Description
Public class AddColumnsSettings
This class describes the settings used when performing the AddColumns(DataSource, AddColumnsSettings) operation on a DataTable.
Public class AddRowsSettings
This class describes the settings used when performing the AddRows(DataSource, AddRowsSettings) operation on a DataTable.
Public class BaseMap
Maps row indexes between a base view and a derived view. A base view is typically a DataTable and a derived view is a DataView.
Public class BinaryLargeObject
Represents a value of datatype Binary. The inner representation of the data is not accessible directly, instead a BinaryLargeObject is created from a byte stream and the data is retrieved through a byte stream.
Public class CalculatedColumn
An instance of this class can be retrieved from a DataColumn using the AsT method when the column type of the DataColumn is Calculated. This class is used for modifying the calculated column.
Public class Calculation
Abstract class representing a calculation.
Public class CalculationPropertyNames
Contains property name constants for the public properties of Calculation.
Public class ColumnRelation
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])'.
Public class ColumnRelationCollection
A collection of ColumnRelation objects.
Public class ColumnRelationCollectionPropertyNames
The property names for ColumnRelationCollection.
Public class ColumnsChangedResult
This is a report on the changes in a DataTable after a large operation such as ReplaceData(DataSource) is performed. It should be used to notify the user of the changes.
Public class DataColumn
This is a data column which is part of a data table and can be used to retrieve data on row values, hierarchies and properties. The data column implements the IDataColumn which is to be used for non-modification operations on the data column. This class has no public constructors, see the DataColumnCollection class for methods which create data columns.
Public class DataColumnPropertyNames
Contains property name constants for the public properties of DataColumn.
Public class DataColumnCollection
This is a collection of DataColumn columns in a DataTable. This class is used to retrieve columns and to add new columns.
Public class DataColumnCollectionPropertyNames
Contains property name constants for the public properties of DataColumnCollection.
Public class DataColumnProperties
Represents a collection of the properties in a column.
Public class DataColumnPropertiesDefaultProperties
Contains predefined name constants for the standard column properties.
Public class DataColumnSignature
A data column signature is used to identify matching columns in the context of linked data. It contains certain key properties, such as the name, data type, and external id of a previously known column.
Public class DataColumnSignatureCollection Obsolete.
A collection of DataColumnSignature objects.
Public class DataErrorValue Obsolete.
Represents a data error value. Contains some information about the reason why a value is invalid. Instances of this class are immutable.
Public class DataFilteringSelection
This is a DataSelection representing a filtering in the DataTables as a subset of the rows.
Public class DataFilteringSelectionPropertyNames
Contains property name constants for the public properties of DataFilteringSelection.
Public class DataFilteringSelectionCollection
This a collection of the DataFilteringSelections. This collection can be retrieved from the DataManager.
Public class DataFilteringSelectionCollectionPropertyNames
Contains property name constants for the public properties of DataFilteringSelectionCollection.
Public class DataFlow
Represents a flow of data from the DataSource through an ordered set of DataTransformation's.
Public class DataFlowBuilder
This class is a builder that can be used to dynamically create a DataFlow instance.
Public class DataHierarchy
A potentially multilevel index of a data column.
Public class DataHistoryBuilder
Represents a builder class to create detail information for the data history. The builder is used to add information to the data history for custom extensions such as DataTransformation, DataSource, Calculation, and so forth.
Public class DataLevel
A single level in a DataHierarchy.
Public class DataLevelCollection
A collection of the levels in a DataHierarchy.
Public class DataLoadReport
Captured error messages during load of (typically linked) data. This can be retrieved from the LoadReport.
Public class DataLoadReportItem
A categorized message item.
Public class DataManager
A DataManager contains the data for an analysis.
Public class DataMarkingSelection
This is a DataSelection representing a marking of rows in the DataTables.
Public class DataMarkingSelectionPropertyNames
Contains property name constants for the public properties of DataMarkingSelection.
Public class DataMarkingSelectionCollection
This a collection of the DataMarkingSelection objects. This collection can be retrieved from the DataManager.
Public class DataMarkingSelectionCollectionPropertyNames
Contains property name constants for the public properties of DataMarkingSelectionCollection.
Public class DataNode
A node in a DataNodeCollection.
Public class DataNodeCollection
A collection of nodes in a hierarchy level.
Public class DataProperty
Definition of a data property.
Public class DataPropertyPropertyNames
Contains property name constants for the public properties of DataProperty.
Public class DataPropertyRegistry
The DataProperty registry is part of the DataManager and contains the properties that can be defined in the analysis. All properties (metadata) that are set must be defined in this registry.
Public class DataPropertyRegistryPropertyNames
Contains property name constants for the public properties of DataPropertyRegistry.
Public class DataReader Obsolete.
Provides reading of a forward-only stream of data rows.
Public class DataRelation
This class describes a relation between two DataTables. The relations are contained in a DataRelationCollection, use the Add(DataTable, DataTable, String) method to add new relations.
Public class DataRelationPropertyNames
Contains property name constants for the public properties of DataRelation.
Public class DataRelationCollection
A collection of DataRelation objects.
Public class DataRelationCollectionPropertyNames
Contains property name constants for the public properties of DataRelationCollection.
Public class DataRow
Flyweight row class used for iterating over a data table.
Public class DataRowCursor
Class for sequential scanning through the rows of a data set defined by a collection of columns.
Public class DataRowReader
Represents a resettable iterator of rows values. It is used to retrieve data from a DataSource or DataTransformation.
Public class DataRowReaderColumn
Represents a column returned by a DataRowReader.
Public class DataRowReaderColumnCollection
Represents a collection of the DataRowReaderColumns that a DataRowReader returns.
Public class DataSaveSettings
Container for data-related save settings. This class is set on the DataManager class and defines how the data should be stored when saving the document.
Public class DataSelection
This is the base class for all selections. A selection is an object that defines a subset of rows as a RowSelection for all data tables in the document.

See the DataMarkingSelection and DataFilteringSelection for concrete classes.

Public class DataSelectionPropertyNames
Contains property name constants for the public properties of DataSelection.
Public class DataSource
Abstract class for data sources. Used when loading and saving linked data.
Public class DataSourceConnection
Represents an open connection to a data source.
Public class DataTable
A DataTable is a collection of columns and metadata.
Public class DataTablePropertyNames
Contains property name constants for the public properties of DataTable.
Public class DataTableCollection
A collection of DataTable objects. The collection of data tables exists in the DataManager.
Public class DataTableCollectionPropertyNames
Contains property name constants for the public properties of DataTableCollection.
Public class DataTableProperties
The collection of the properties (metadata) of a DataTable.
Public class DataTableSaveSettings
Save settings for a data table. This can be added or retrieved from the DataTableSettings list.
Public class DataTransformation
Represents a transformation of data, when data is imported from a DataSource it may optionally be transformed by one or more transformations. A transformation takes a DataRowReader as input and a DataRowReader as output with the transformed rows.
Public class DataTransformationConnection
Represents a connected DataTransformation. The connection is created when the transformation is bound to a DataRowReader that is used as input to the transformation.
Public class DataType
This class contains information about a TIBCO Spotfire data type and the properties of that data type. This is an enumeration class with one static instance for each of the supported data types.
Public class DataValue
An abstract base class for flyweight data value containers. More precisely, a DataValue instance contains a value of a particular DataType, and thus every DataValue has a corresponding DataType. (This is not necessarily true for the methods marked Obsolete in this class.) Instances of the generic subclass are normally used, often explicitly, and this non-generic base class is provided only for convenience in contexts where the generic type is not known, or variable. Note that this class is intended as a flyweight, that is, as a reusable container. This means that it is not optimized for memory and is unsuitable for representing arrays or matrices of data values, where a separate DataValue instance is used for each cell. Consider using a more compact representation of the values for such purposes. The DataValue class is not serializable and should not be used for persistent storage.
Public class DataValueT
Generic flyweight data value container.
Public class DataValueCollection
A collection of the row values in a IDataColumn.
Public class DataValueCursor
Non-generic cursor class for efficient enumeration of data values.
Public class DataValueCursorT
Generic cursor class for efficient enumeration of data values.
Public class DataValueProperties
A class holding properties for a data value.
Public class DataValueTuple
Represents a collection of data values that serves as input to produce a result value.
Public class DataView
A DataView is a derived view which values are derived from a DataTable. It cannot be added to the DataTableCollection. A DataView cannot be serialized to the document.
Public class DataViewPropertyNames
Contains property name constants for the public properties of DataView.
Public class DistinctDataValue
A wrapper class that holds a value that can occur in the column of a data table. The class provides equality and an ordering of the values even if they are of different underlying types. Values of the class can therefore be used in UndoableList and UndoableDictionary.
Public class HierarchyColumn
An instance of this class can be retrieved from a DataColumn using the AsT method when the column type of the DataColumn is Hierarchy. This class is used for modifying the hierarchy column.
Public class HierarchyDefinition
This is a definition of a hierarchy.
Public class HighlightSelection
This is a highlight selection, it changes when the user moves the mouse cursor over the plots. A highlight selection is a special kind of selection which should only be used from user interface code and the events from this selection can only be received by external event handlers.
Public class HighlightSelectionPropertyNames
Contains property name constants for the public properties of DataFilteringSelection.
Public class IndexSet
A bitset-like class that represents a collection of indices, typically a subset of the rows in a IDataColumn or similar.
Public class MutableValueCursorT
A generic mutable cursor class that should be used when reading data from a DataRowReader.
Public class NameString
Provides static utility methods for validating and creating strings representing names.
These methods should be used when creating names for elements in the data manager, like a data table or a data column.
Public class NodeToRowIndexMap
A mapping between the rows in the column/table and the nodes in a hierarchy level.
Public class PartialDataLoadReport
Represents a report containing error messages from a data loading phase.
Public class PersistentDataView
This is a wrapper class around a DataView which performs the code for serializing the DataView since a data view is not possible to persist.
Public class PersistentDataViewPropertyNames
Contains property name constants for the public properties of PersistentDataView.
Public class ResultColumn
An instance of this class can be retrieved from a DataColumn using the AsT method when the column type of the DataColumn is Result. This class is used for modifying the result column.
Public class ResultProperties
Represents the metadata about the result from a data source, transformation or calculation. These properties are used to set properties on the resulting data table.
Public class RowSelection
This is a representation of a selection of rows in a table. It is currently created from an enumeration of row indexes or IndexSet but may be extended in the future to support symbolic marking.
Public class TagsColumn
An instance of this class can be retrieved from a DataColumn using the AsT method when the column type of the DataColumn is Tags. This class is used for modifying the tags column.
Structures
  Structure Description
Public structure Range
A Range represents a double-precision floating-point interval.
Interfaces
  Interface Description
Public interface IDataColumn
This is the interface for reading data from a column. You should not implement this interface. Use the ColumnBuilderT class to create columns.
Public interface IDataNodeProducer
This is the interface for creating data nodes.
Public interface IDataValueProducer
Producer interface for data values, used with enumerators.
Public interface IValidator
Validates an item of a specific DataType.
Public interface IValidatorT
Validates an item of the specified type.
Delegates
  Delegate Description
Public delegate DataTransformationConnectionTransformationExecutor
A delegate for executing a transformation and returning a DataRowReader.
Public delegate DataValueTransformS, T
Generic data value transform.
Public delegate QueryExecutor Obsolete.
A delegate for executing query and returning a DataReader.
Public delegate QueryExecutor2
A delegate for executing query and returning a DataRowReader.
Enumerations
  Enumeration Description
Public enumeration CalculationExecutionPromptMode
Specifies prompt modes for calculation executions.
Public enumeration CalculationUpdateBehavior
Specifies the update behavior for calculations.
Public enumeration DataColumnType
Enum for IDataColumn categories. The DataColumnType for an IDataColumn can be retrieved from the ColumnType property.
Public enumeration DataErrorCodes Obsolete.
Enum for data error categories.
Public enumeration DataPropertyAttributes
Attributes for a DataProperty. Custom data properties should almost always use DefaultAttributes.
Public enumeration DataPropertyClass
The different classes that a DataProperty can belong to.
Public enumeration DataSelectionCombinationMethod
Defines how to combine data selections.
Public enumeration DataSelectionOperation
Enum for data selection operations.
Public enumeration DataSelectionResetBehavior
Specifies the reset behavior of a DataSelection. This setting specifies what the value of a selection should be by default.
Public enumeration DataSelectionScope Obsolete.
Specifies the scope of a DataSelection. Determines which tables are affected by a setting a selection.
Public enumeration DataSourcePromptMode
Defines how a DataSource should prompt a user for settings when loading data.
Public enumeration HierarchyNestingMode
Determines how each level in the Hierarchy should relate to the next level.
Public enumeration JoinType
Describes which join type that should be used when joining two tables into a new table. This is used in the AddColumnsSettings class to specify how the join should be performed.
Public enumeration LimitingMarkingsEmptyBehavior
Defines alternatives for visualization of empty data selections.
Public enumeration RelatedRowsPropagation
The behavior for propagation of filter selections between related tables. This is used in DataFilteringSelection.
Public enumeration SortOrder
Defines the order for a sort operation.