Operation Details |
Description: | Counts organization unit resource records by organization unit and resource id and resource status.. |
Sterotype: | ns |
SQL |
SELECT COUNT(organisationUnitResourceID) INTO :organisationUnitResourceCount FROM OrganisationUnitResource WHERE organisationUnitID = :organisationUnitID AND resourceID = :resourceID AND recordStatus = :recordStatus |