Skip to main content
Kofax

Batch Field Value location in Capture database

17542

QAID # 17542 Published

Question / Problem:

To trace Batches with unique values in Batch Fields, is it necessary to know where this value is stored in the Kofax Database.

Where can these be found?

Answer / Solution:

The Batch Field Value is stored in the UserField table in the ACSystem database. This table will also contain the BatchID.

Query SELECT * FROM UserField to see the Batch Field value.

(Document Index Fields are stored in BatchField table.)

The Batch information will be available in the SQL Server database only when the option to "Store batches in SQL Server" is selected on the Database tab in DBUtil. Otherwise the Batch information will be stored in the Batch .mdb file (Access), for which the password cannot be provided.

Applies to:

Product Version
CAPTURE 10.0
  10.1
  10.2
  11.0