Operation Details |
Description: | Counts the number of active record with a specified name. |
Sterotype: | ns |
SQL |
SELECT COUNT (*) INTO :recordCount FROM VerifiableDataItem WHERE name = :name AND verificationCategoryID = :verificationCategoryID AND recordStatus <> :recordStatus |