An SQL command for extracting an individual record from the database

Key: db.single_item_sql
Type: String
Can be set in: collection.cfg


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



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