Class RVSqlBasedDataSourceItem

The base item class used to represent a dataset from one of the supported database systems.

Inheritance
System.Object
RVDataSourceItem
RVSqlBasedDataSourceItem
RVRedshiftDataSourceItem
RVOracleDataSourceItem
RVSqlPDSDataSourceItem
RVSyBaseDataSourceItem
Inherited Members
Namespace: Reveal.Sdk.Data
Assembly: Infragistics.Reveal.DataLayer.dll
Syntax
public abstract class RVSqlBasedDataSourceItem : RVDataSourceItem, IDataSourceItem

Constructors

RVSqlBasedDataSourceItem(RVDashboardDataSource)

Declaration
protected RVSqlBasedDataSourceItem(RVDashboardDataSource dataSource)
Parameters
Type Name Description
RVDashboardDataSource dataSource

RVSqlBasedDataSourceItem(RVDashboardDataSource, BaseDataSourceItem)

Declaration
public RVSqlBasedDataSourceItem(RVDashboardDataSource dataSource, BaseDataSourceItem modelDataSourceItem)
Parameters
Type Name Description
RVDashboardDataSource dataSource
Infragistics.ReportPlus.DashboardModel.BaseDataSourceItem modelDataSourceItem

Properties

CustomQuery

(Optional) Custom SQL query to use when getting data

Declaration
public string CustomQuery { get; set; }
Property Value
Type Description
System.String

Database

Name of the database to connect to, optional as this value is usually specified in the data source object. If set, it has priority over the value specified in the data source object.

Declaration
public string Database { get; set; }
Property Value
Type Description
System.String

Table

Name of the table (or view) to get data from

Declaration
public string Table { get; set; }
Property Value
Type Description
System.String

Methods

CreateModelDataSourceItem()

Declaration
public override BaseDataSourceItem CreateModelDataSourceItem()
Returns
Type Description
Infragistics.ReportPlus.DashboardModel.BaseDataSourceItem
Overrides
RVDataSourceItem.CreateModelDataSourceItem()