db.primary_id_column

Background

This parameter specifies the name of the column in which the database query returns each record’s unique primary key, which is required to uniquely identify each record.

The column is expected to be unique for each record, but if repeats occur, only the last record in the result set will be indexed by Funnelback.

Please note that this value is case-sensitive, and may be required to be uppercase by some database systems (i.e. Oracle).

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.primary_id_column key, and set the value. This can be set to any valid String value.

Default value

db.primary_id_column=id

Examples

db.primary_id_column=DEPARTMENT_ID