Skip to content

db.single_item_sql (collection.cfg setting)

Description

This parameter specifies the SQL query to execute to fetch an individual record with a particular ID from the database. The required ID is indicated by the $item_key token, which is replaced with the needed value during execution.

Funnelback uses this query to fetch records which have been marked as new or changed through a line in the update event table.

Please note that with most database drivers, a semicolon (;) should not be included at the end of the query.

Default value

(none)

Example

db.single_item_sql=select * from main where id = $item_key

See also

top

Funnelback logo
v15.14.0