we can fetch the required data from Two tables with the help of a small job.
Tables : SecurityRole & SecurityUserRole
static void SecurityRole(Args _args)
{
SecurityRole securityRole;
SecurityUserRole securityUserRole;
while select RecId,name from securityRole
join securityUserRole
where securityRole.RecId == SecurityUserRole.SecurityRole
//&& SecurityUserRole.User == curUserId() //for current user roles
{
info(strFmt("%1 - %2",SecurityUserRole.User,securityRole.name));
}
}
No comments:
Post a Comment