Skip to main content

Database Supplier

Overview





Details


Name:

Database Supplier

Prefix:

db

Supported Content:


Provided By:

Connector for SQL Databases

Supported Keys


The following are the list of keys for which this supplier will return a value:

Key
Content Types
Return Type

Description

[table name]

String

DbTable

Table object with the given name from the specified data source. Can be used in a reporter or passed to other suppliers

[table name].[column key]

String

DbRow

From the specified data source, selects the unique row from the table with the given name with the key value supplied.

[table name] where [column] eq [X]

String

List of DbRow

Queries the table where column name = X

[table name] where [column] neq [X]

String

List of DbRow

Queries the table where column name <> X

[table name] where [column] like [X]

String

List of DbRow

Queries the table where column name like X

Examples




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.