Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Tabular Form
Tabular Form [message #455398] Tue, 11 May 2010 07:48 Go to next message
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
Re: Tabular Form [message #455663 is a reply to message #455398] Wed, 12 May 2010 07:50 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
write validation process on page item (enter with submit option)
Previous Topic: PSP pages
Next Topic: Post calculation computation
Goto Forum:
  


Current Time: Thu Jun 04 20:02:39 CDT 2020