db.single_item_sql

Background

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.

Setting the key

Set this configuration key in the search package or data source configuration.

Use the configuration key editor to add or edit the db.single_item_sql key, and set the value. This can be set to any valid String value.

Default value

(none)

Examples

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