Operation Details |
Description: | returns a list of resources of the specified type at the specified location |
Sterotype: | nsmulti |
SQL |
SELECT Resources.resourceID, Resources.name, Resources.typeCode, Resources.statusCode, Resources.resourceStatus, LocationResourceLink.locationID INTO :resourceID, :resourceName, :resourceTypeCode, :statusCode, :resourceStatus, :locationID FROM Resources, LocationResourceLink WHERE LocationResourceLink.locationID = :locationID AND Resources.typeCode = :typeCode AND Resources.resourceID = LocationResourceLink.resourceID |