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

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  

References

Add any references to other internal or external articles