Oracle Application Express (APEX)


Is it possible to display different select list tabular form based on different user


Hello, For a tabular form (APEX 5.0.3). I wonder how to handle this situation: For different user (login name), display different select list (which will be static value list then), Then based on the selection of above column, I need to populate another column's contents. First thought is to add one more hidden column to hold user name, then decides the select list accordingly.  Is there other easier way, such as just by sql query to deal with it?  Thanks very much!
Easiest way would be to just do it through your SQL query.  You just need to have the necessary columns available in your lookup table.  Or through the use of an intersect table that had user/role with valid lookup values.
select vfrom (select 'Ready for Validation' v,       'A' user_type  from dual union allselect 'Previously Validated' v,       'A' user_type  from dual union allselect 'Revert to Update' v,       'A' user_type  from dual union allselect 'Validation Complete' v,       'B' user_type  from dual union allselect 'REvision Needed' v,       'B' user_type  from dual)where user_type = :P1_USR_TYP
Thanks Pmon, need to consult bit more details:Can you help check what's wrong with this pl sql function body returning sql query, it returns the second line of the query while APEX doesn't complain on the syntax: declarev_list varchar2(2000);v_user varchar2(20):=v('APP_USER');v_table number; beginselect count(apex_user_id) into v_table from tbl_apex_user where login=v_user; if v_table>0 then v_list:= 'select ''Ready for Validation'' from dualunion allselect  ''Previous Validated'' from dualunion allselect ''Revert to Update'' from dualas statusfrom dual'; elsev_list:= 'select ''Validation Complete'' from dualunion allselect  ''Revision Needed'' from dualas statusfrom dual';end if; return v_list;end;
Jian-cdo wrote: Thanks Pmon, need to consult bit more details:Can you help check what's wrong with this pl sql function body returning sql query, it returns the second line of the query while APEX doesn't complain on the syntax: declarev_list varchar2(2000);v_user varchar2(20):=v('APP_USER');v_table number; beginselect count(apex_user_id) into v_table from tbl_apex_user where login=v_user; if v_table>0 then v_list:= 'select ''Ready for Validation'' from dualunion allselect ''Previous Validated'' from dualunion allselect ''Revert to Update'' from dualas statusfrom dual'; elsev_list:= 'select ''Validation Complete'' from dualunion allselect ''Revision Needed'' from dualas statusfrom dual';end if; return v_list;end;Jian-cdo probably failing bc you need a display and return for an lov.  you're only returning an sql statement with a single column. Cheers

Related Links

Upgrade apex 4.2 to 5.03 - refused connection when try to connect remotely
Apex 5.0 Apex Application Archive Application  wwv_flow.accept file always wants to download or save instead of execute.
P-Track Email
DBMS_CRYPTO in APEX 5 with Oracle 11G
How to change Apex URL into any specific URL?
Bottom Splitter cannot be moved in Internet Explorer
Learning oracle apex
report error: ORA-20001: Error fetching column value: ORA-01403: no data found ORA-06510: PL/SQL: unhandled user-defined exception
jquery dailog
calling edit button  and it doesnt retrive all the values of the form
Tag Cloud Plug-in Link to Modal generates Javascript Error
Tabular form with variable column widths
Navigating back to Classic report makes it refresh, how do I stop that?
automatic creation of application
ORA-06550 with PL/SQL code process
How to deploy apex application changes to production?

Categories

ORACLE DEV
WebCenter Content
Database Upgrade
Multimedia (formerly i...
Database Mobile Server...
User Groups
Streams
Calendar SDK
SOA Suite
Performance Tuning (Ko...
Communications Service...
Automatic Storage Mana...
Marketing
Data Sourcing
Upgrades
QAZone e-TEST suite Fo...
QA/Testing
WebLogic
WebLogic Portal
Application Integratio...
WebLogic Server - Secu...
MessageQ
weblogic.developer.int...
weblogic.support.install
weblogic.developer.int...
weblogic.developer.int...
WebLogic Integration N...
BEA Tuxedo 10.0 Beta
Portlets
ALUI CodeShare
SOA & Web Services (Ch...
BEA WebLogic Server (C...
BEA WebLogic Portal (C...
Exadata
Java APIs
Java Essentials
Java HotSpot Virtual M...
Networking
CLDC and MIDP
Java Runtime Environme...
Developing Application...
Java Archive (JAR) Fil...
Swing [Archive]
Java Real-Time
Java BluePrints [ARCHIVE]
E-mail, Calendar, & Co...
初心者の部屋
Business
Exalogic Elastic Cloud
Oracle Tuxedo (Japanese)
Israel Oracle User Gro...
VirtualBox
Engineered Systems
Oracle Cloud Services ...
Oracle Documents Cloud...
Software-as-a-Service
General Database Discu...
Eloqua For Sales
Benelux Eloqua User Group
E10 Lead Scoring
Eloqua 9 Clients
Eloqua Share & Learn
Huntsville, Alabama El...
JDBC & UCP
#Java20
Systems Track
OMC - Industry Solutio...
Oracle Mobile Cloud Se...
Professional Services ...
Oracle Academy - Commu...
Article Archive
Java.net Forge Sunset
IDGOUG - (Internationa...
Home of Oracle Certifi...
JavaScript - Nashorn
Marketing Elo[q]ution ...
Cloud Accelerate
Eclipse開発ツール
Service Supply Chain
From MOOC1
Java Puzzle Ball
Oracle Datasource for ...
Markies: Marketing & S...
产品
OA Framework (Korean)
JD Edwards World Gener...
Financial Consolidation
Administration
tuxedo.general
jrockit.developer.inte...
Tuxedo (Chinese)
Web Application Develo...
论坛工作室
Telecom Technology (Ch...
J2ME Development (Chin...
.NET (Japanese)

Resources

Encrypt Message



code
soft
python
ios
c
html
jquery
cloud
mobile