Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » shuttle box
shuttle box [message #452270] Wed, 21 April 2010 00:02 Go to next message
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
Re: shuttle box [message #477719 is a reply to message #452270] Mon, 04 October 2010 01:48 Go to previous messageGo to next message
sathishraj
Messages: 53
Registered: July 2010
Location: chennai
Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: shuttle box [message #477838 is a reply to message #452270] Mon, 04 October 2010 13:52 Go to previous message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
I have not worked on this as yet. Posting the link below thinking that it would be helpful to you.
http://technology.amis.nl/blog/1753/creating-a-shuttlebox-in-apex
Have a look at it.

Regards
Ved
Previous Topic: Need Help
Next Topic: Trying to determine Excel import abilities
Goto Forum:
  


Current Time: Thu Mar 28 09:58:14 CDT 2024