Package io.revealbi.core.data

Class RVSqlBasedDataSourceItem

java.lang.Object

io.revealbi.core.data.RVDataSourceItem

io.revealbi.core.data.RVSqlBasedDataSourceItem

Direct Known Subclasses:

RVOracleDataSourceItem, RVRedshiftDataSourceItem, RVSqlPDSDataSourceItem, RVSyBaseDataSourceItem

public abstract class RVSqlBasedDataSourceItem
extends RVDataSourceItem

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

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	RVSqlBasedDataSourceItem(RVDashboardDataSource dataSource)

Method Summary

Modifier and Type	Method	Description
String	getCustomQuery()	(Optional) Custom SQL query to use when getting data.
String	getDatabase()	Name of the database to connect to, optional as this value is usually specified in the data source object.
String	getTable()	Name of the table (or view) to get data from.
String	setCustomQuery(String value)	(Optional) Custom SQL query to use when getting data.
String	setDatabase(String value)	Name of the database to connect to, optional as this value is usually specified in the data source object.
String	setTable(String value)	Name of the table (or view) to get data from.

Methods inherited from class io.revealbi.core.data.RVDataSourceItem

getDataSource, getDefaultRefreshRate, getDescription, getId, getSubtitle, getTitle, setDataSource, setDefaultRefreshRate, setDescription, setId, setSubtitle, setTitle

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

RVSqlBasedDataSourceItem

protected RVSqlBasedDataSourceItem(RVDashboardDataSource dataSource)

Method Details

setDatabase

public String setDatabase(String value)

Name of the database to connect to, optional as this value is usually specified in the data source object.

Parameters:

value -

Returns:

getDatabase

public String getDatabase()

Name of the database to connect to, optional as this value is usually specified in the data source object.

Returns:

setTable

public String setTable(String value)

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

Parameters:

value -

Returns:

getTable

public String getTable()

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

Returns:

setCustomQuery

public String setCustomQuery(String value)

(Optional) Custom SQL query to use when getting data.

Parameters:

value -

Returns:

getCustomQuery

public String getCustomQuery()

(Optional) Custom SQL query to use when getting data.

Returns: