Operation Details
Description: Perform a readmulti to retrieve the administrator. The administrator could be a user or any other organization object.
Sterotype: nsmulti
SQL
SELECT
  AdministrationConcernRole.startDate,
  AdministrationConcernRole.endDate,
  AdministrationRole.statusCode,
  AdministrationConcernRole.typeCode,
  AdministrationConcernRole.administrationConcernRoleID,
  OrgObjectLink.userName,
  OrgObjectLink.orgObjectType,
  OrgObjectLink.orgObjectReference
INTO
  :startDate,
  :endDate,
  :statusCode,
  :typeCode,
  :administrationConcernRoleID,
  :userName,
  :orgObjectType,
  :orgObjectReference 
FROM
  AdministrationRole,
  AdministrationConcernRole,
  OrgObjectLink 
WHERE concernRoleID = :concernRoleID 
  AND AdministrationRole.administrationRoleID = AdministrationConcernRole.administrationRoleID 
  AND AdministrationRole.orgObjectLinkID =OrgObjectLink.orgObjectLinkID 
  AND 
  (
    AdministrationConcernRole.startDate <= :currentDate 
    AND 
    (
      AdministrationConcernRole.endDate IS NULL 
    ) 
  )