Database SQL Operation: IssueResolutionLink.searchByIssueConfigIDAndStatus
Description: | Returns a list of active resolutions associated with a particular issue. |
Sterotype: | nsmulti |
SELECT
IssueResolutionLink.resolutionConfigurationID,
ResolutionConfiguration.resolution
INTO
:resolutionConfigurationID,
:resolution
FROM
IssueResolutionLink,
ResolutionConfiguration
WHERE IssueResolutionLink.issueConfigurationID = :issueConfigurationID
AND IssueResolutionLink.recordStatus = :recordStatus
AND IssueResolutionLink.resolutionConfigurationID = ResolutionConfiguration.resolutionConfigurationID
|