Skip to main content
Kofax

Identify a field value in the database using a known Batch ID

308459

Question / Problem: 

How to identify the field value on the database knowing the batch ID:

Example:

How to identify the "Markview Batch Number" on the database for Batch ID 729:

 

Answer / Solution: 

 

1) Identify the the field name in the UserFldDefID table using the below query:

 

SELECT [UserFldDefID]

   ,[Name]

   ,[BatchDefID]

   ,[Required]

   ,[FieldDefID]

   ,[DefaultValMacro]

   ,[DefaultValActual]

   ,[DisplayOrder]

   ,[DisplayLabel]

   ,[Hidden]

   ,[Sticky]

   ,[PublishedBatchDefID]

   ,[AdminID]

   ,[Referenced]

 FROM [ACDBCS].[dbo].[UserFldDef] where name = 'MarkViewBatchNumber'

 

This query will return an UserfldDefID for Name MarkViewBatchNumber

Query results:

UserFldDefID  =59     <------

Name = MarkViewBatchNumber 

BatchDefID = 46

Required = 1

FieldDefID = 300

DefaultValMacro ............

59 MarkViewBatchNumber 46 1 300 0

 

2) Query the the UserField table by Batch ID as showed below and then check the correspondent value for the UserFldDefID

 

SELECT TOP (1000) [UserFieldID]

   ,[UserFldDefID]

   ,[BatchID]

   ,[Value]

   ,[Valid]

 FROM [ACDBCS].[dbo].[UserField] Where BatchID = '729'

Query results:

UserFieldID = 1

UserFldDefID = 59

BatchID =  729

Value = 30

Valid = NULL

 

Resuming:

Markview Batch Number for batch 729 is 30

 

Applies to:  

Product Version
CAPTURE 10.0
  10.1
  10.2
  11.0

 

  • Was this article helpful?