| Tabular Form [message #455398] |
Tue, 11 May 2010 07:48  |
myadmya
Messages: 7
Registered: April 2010
Location: Dublin
|
Junior Member |
|
|
Hi,
I was wondering could anybody help me. I currently have a tabluar form that diplays all the roles in my system i.e "ADMIN", "BUSINESS APPROVER". How can I restrict the roles once the user has ticked a selection? For example a user can have the roles of "DEVELOPER" and a "CODE CHECKER" at the same time, however they may not have an "ADMIN" role if they have these roles. So when admin is ticked I want hide these two roles. Would anybody now how to do it.
The name of my table is application_role. The below query which is used to populate the tabular form, selects all application roles that are not currently assigned to the user.
select htmldb_item.checkbox(30,rownum)"Select",x.role
from (select htmldb_item.display_and_save(3 1,role)role from application_role
where role not in(select role
from user_role
where username = :P11_USERNAME)) x
Please see attached screen shot
Thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
