| shuttle box [message #452270] |
Wed, 21 April 2010 00:02  |
priyapinky
Messages: 7
Registered: April 2010
|
Junior Member |
|
|
Hi
I have created a shuttle box and given static columns in it , i need to display the data only for the select column on the right side box ,
region has the source with the code below :
{code}
select
:P1_REQUIRED_COLUMNS
from DW_RFA_JOBDATA
where FINISH_TIME >= :P1_START_DATE
and FINISH_TIME < :P1_END_DATE
and CLUSTER_CODE = :P1_CLUSTER_CODE
AND ( QUEUE_CODE = :P1_QUEUE_CODE
OR (QUEUE_CODE = QUEUE_CODE AND nvl(:P1_QUEUE_CODE,'1') = '-1'))
AND (JOB_ID = TO_NUMBER(:P1_JOB_ID) OR (1 = 1 AND :P1_JOB_ID is null))
AND ( USER_NAME = :P1_USER
OR (USER_NAME = USER_NAME AND :P1_USER is null))
AND (JOB_ARRAY_INDEX = :P1_JOB_ARRAY
OR (JOB_ARRAY_INDEX = JOB_ARRAY_INDEX AND :P1_JOB_ARRAY IS NULL))
AND JOB_EXIT_STATUS = (CASE :P1_JOB_STATUS
WHEN '1'
THEN 'EXIT'
WHEN '2'
THEN 'DONE'
ELSE JOB_EXIT_STATUS END)
AND ( HOST_NAME = :P1_HOST_NAME
OR ( HOST_NAME = HOST_NAME AND :P1_HOST_NAME IS NULL ))
{code}
P1_REQUIRED_COLUMNS is the name of my shuttle box,i dont get any data in my report when i run with above query , how do i link the data columns of my shuttle box to the source query ..
if i remove : and give list of all the columns i have then i get all the data for all the columns, even though i select just 2 columns in the shuttle box....
Please help me getting the data for selected right hand side columns....
I am new to oracle apex....
If a code is there please let me knwo where it has to be written ? and what properties needs to be changed ...
Thanks In Advance
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
