project QadFinancials > class BRole > business logic query UsrRoleByRole

Description

User information by role


Parameters


iiRoleIDintegerRoleId
icRoleNamecharacterRoleName


query condition


  each Role where
Role.Role_ID = iiRoleID AND
Role.RoleName = icRoleName

      each UsrRole (inner-join) where
UsrRole.Role_ID = Role.Role_ID AND

          first Usr (inner-join) where
Usr.Usr_ID = UsrRole.Usr_ID AND


query resultset tqUsrRoleByRole


field namedata typedb fielddescription
tiRole_IDintegerRole.Role_IDRecord ID
tcRoleNamecharacterRole.RoleNameRole Name
tiUsr_IDintegerUsr.Usr_IDRecord ID
tcUsrInitialscharacterUsr.UsrInitialsUsrInitials
tlUsrIsActivelogicalUsr.UsrIsActiveActive
tcUsrLogincharacterUsr.UsrLoginLogin
tcUsrMailAddresscharacterUsr.UsrMailAddressE-mail Address
tcUsrNamecharacterUsr.UsrNameUser Name
tiUsrRole_IDintegerUsrRole.UsrRole_IDRecord ID


Internal usage


QadFinancials
method BCInvoice.PostSave
method MfgNotification.ProcessMfgNotification