Skip to main content
Kofax

Query to find a batch with a special value in a batchfield.

Article # 3045590 - Page views: 3

Issue

It is possible to find a batch with a specific value in a batch field by running a SQL Query?

Solution

Yes, this can be done by using the following Query

SELECT    UserField.BatchID, UserFldDef.Name, UserField.Value
FROM      Batch INNER JOIN
             UserField ON Batch.BatchID = UserField.BatchID INNER JOIN
             UserFldDef ON UserField.UserFldDefID = UserFldDef.UserFldDefID
WHERE    (UserFldDef.Name = N'BATCHFIELD_NAME') AND (UserField.Value = N'BATCHFIELD_VALUE')

 

Level of Complexity 

Easy

 

Applies to  

Product Version Build Environment Hardware
Kofax Capture all      

References

Add any references to other internal or external articles

 

 

Article # 3045590
  • Was this article helpful?