Operation Details |
Description: | Return a list of resource details by specified location. |
Sterotype: | nsmulti |
SQL |
SELECT Resources.resourceID, Resources.name, Resources.typeCode, Resources.statusCode, Resources.resourceStatus, Resources.versionNo, LocationResourceLink.locationID INTO :resourceID, :resourceName, :resourceTypeCode, :statusCode, :resourceStatus, :versionNo, :locationID FROM Resources, LocationResourceLink WHERE LocationResourceLink.locationID = :locationID AND Resources.resourceID = LocationResourceLink.resourceID ORDER BY resourceStatus ASC |