Skip to main content
A newer version of this page is available. .

SqlDataSource Class

An SQL data source that provides data for the dashboard.

Declaration

export class SqlDataSource extends DataSource

Inherited Members

DevExpress.Dashboard.Model.OlapDataSource.calculatedFields
DevExpress.Dashboard.Model.OlapDataSource.componentName
DevExpress.Dashboard.Model.OlapDataSource.filter
DevExpress.Dashboard.Model.OlapDataSource.hasCalculatedFields
DevExpress.Dashboard.Model.OlapDataSource.hasFilter
DevExpress.Dashboard.Model.OlapDataSource.name
DevExpress.Dashboard.Model.OlapDataSource.supportDataMembers
DevExpress.Dashboard.Model.OlapDataSource.getJson
DevExpress.Dashboard.Model.OlapDataSource.getUniqueNamePrefix

constructor

Initializes a new instance of the SqlDataSource class.

Declaration

constructor(
    dataSourceJSON?: any,
    serializer?: DevExpress.Analytics.Utils.ModelSerializer
)

Parameters

Name Type Description
dataSourceJSON any

A JSON object used for dashboard deserialization. Do not pass this parameter directly.

serializer ModelSerializer

An object used for dashboard deserialization. Do not pass this parameter directly.

Properties

connection Property

Declaration

connection: SqlConnection

Property Value

Type
SqlConnection

queries Property

Declaration

queries: ko.ObservableArray<DevExpress.Analytics.Data.Utils.ISqlQueryViewModel>

Property Value

Type
ObservableArray<ISqlQueryViewModel>

Methods

getDisplayNamePrefix Method

Declaration

getDisplayNamePrefix(): string

Returns

Type
string

getInfo Method

For internal use.

Declaration

getInfo(): DevExpress.Analytics.Utils.ISerializationInfoArray

Returns

Type Description
ISerializationInfoArray

An array of objects that provide serialization info.