Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Check Box with Column names
Check Box with Column names [message #286584] Sat, 08 December 2007 08:10 Go to next message
udaytapal
Messages: 6
Registered: December 2007
Location: Navi Mumbai
Junior Member
Hi I am Uday,

In search region i have created Check box using below dynamic LOV:

"SELECT DISTINCT COLUMN_NAME D,COLUMN_NAME R
FROM USER_TAB_COLS WHERE TABLE_NAME="EMP"
ORDER BY 1"

With this i got 8 check boxes in search region(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO).

In 2nd region i have created one report based on one select statement (SELECT * FROM EMP).

Now my question is if i click on EMPNO,ENAME check box i would like to show EMPNO,ENAME columns data only, not other columns information.For doing this which steps should i follow.

REGARDS,
Uday.

Re: Check Box with Column names [message #286666 is a reply to message #286584] Sun, 09 December 2007 11:29 Go to previous message
patrick_wolf
Messages: 11
Registered: August 2007
Location: Vienna, Austria
Junior Member
Add a condition of type "Text in Expression 1 Is Contained in Value of Item in Expression 2" to each of your report columns.

In "Expression 1" you write the name of the column. Eg. EMPNO
In "Expression 2" you write the name of your checkbox page item.

The checkbox page item contains all the selected values as colon delimited list (eg.: EMPNO:ENAME), based on this value the report column is displayed or not.

That should do it
Patrick
Check out my Oracle APEX blog: http://inside-apex.blogspot.com/
Previous Topic: ORA-22921
Next Topic: Query to get the result from a search form
Goto Forum:
  


Current Time: Wed Dec 07 10:30:36 CST 2016

Total time taken to generate the page: 0.08970 seconds