Operation Details
Description: Retrieves a list of associations between a specified user security role and organization quick links.
Sterotype: nsmulti
SQL
SELECT
  QuickLinkSecurityRoleLink.quickLinkSecurityRoleLinkID,
  QuickLinkSecurityRoleLink.quickLinkID,
  QuickLinkSecurityRoleLink.roleName,
  QuickLinkSecurityRoleLink.dateCreated,
  QuickLink.name,
  QuickLink.webAddressID,
  QuickLink.openInModalInd,
  WebAddress.webAddress
INTO
  :quickLinkSecurityRoleLinkID,
  :quickLinkID,
  :roleName,
  :dateCreated,
  :name,
  :webAddressID,
  :openInModalInd,
  :webAddress 
FROM
  QuickLinkSecurityRoleLink,
  QuickLink,
  WebAddress 
WHERE QuickLinkSecurityRoleLink.roleName = :roleName 
  AND QuickLinkSecurityRoleLink.quickLinkID = QuickLink.quickLinkID 
  AND QuickLink.webAddressID = WebAddress.webAddressID