tag:blogger.com,1999:blog-21122514.post2745308689498749656..comments2024-03-23T11:05:13.046+01:00Comments on Dimitri Gielis Blog (Oracle Application Express - APEX): APEX by Example - Default value of ShuttleDimitri Gielishttp://www.blogger.com/profile/16295721159626839167noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-21122514.post-91272185298497670832021-10-15T09:44:43.103+02:002021-10-15T09:44:43.103+02:00Also works by setting the shuttle's "Defa...Also works by setting the shuttle's "Default" to type "SQL Query returning colon delimited list", where the query selects the values to be pre-selected - i.e. in the second list box.Anonymoushttps://www.blogger.com/profile/13801515050689397725noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-32833966126517273512014-09-03T14:56:06.393+02:002014-09-03T14:56:06.393+02:00Thanks it works :) !1!!Thanks it works :) !1!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-29545296492309170472013-08-21T09:35:56.759+02:002013-08-21T09:35:56.759+02:00Hi, just as Patrick Mentioned, here is another way...Hi, just as Patrick Mentioned, here is another way of implementing the solution.<br /><br />Step 1 : Create a shuttle page item with the required LOV with Display and Return values.<br />e.g <br />SELECT DISTINCT QUEUE_MEMBER D, QUEUE_MEMBER R <br />FROM TBL_ISSUES_QUEUE<br /><br />Step 2 : In the same shuttle item under source, choose "source type" as sql query(return colon separated values)<br /><br />Step 3 : In the SQL, you can use listagg function:<br /><br />e.g SELECT listagg(QUEUE_MEMBER , ':') WITHIN GROUP (ORDER BY QUEUE_MEMBER) FROM TBL_ISSUES_QUEUE WHERE (some condition)<br /><br />This will populate the right hand side of the shuttle.<br />Hope it helps.<br /><br />Regards,<br />viczsauravAnonymoushttps://www.blogger.com/profile/13318332489855161788noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-48850279383677930212012-07-10T08:22:18.700+02:002012-07-10T08:22:18.700+02:00Exactly what I needed. Thank you!!Exactly what I needed. Thank you!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-11946288172214388042012-04-17T05:48:45.997+02:002012-04-17T05:48:45.997+02:00Dear Dimitri,
This is gurujothi from India, Am new...Dear Dimitri,<br />This is gurujothi from India, Am new to apex,Just now i came to know about your blog,<br />Thank you for your work,here I have the requirement<br />in my form two columns are there <br />1.leave_type 2.leave_id<br />the first one is LOV and when I select the value for first_column the second one needs to be filled automatically<br />for example.<br /><br />if 1st is casual the second is ca<br />if first is sick the second is si and etc.,<br />how can i get it?<br />Please Help me'<br />Thank you ,<br />With regards,<br />GurujothiAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-36970623360593886302012-03-20T01:48:25.442+01:002012-03-20T01:48:25.442+01:00Big thanks to Ana above for the helpful tip about ...Big thanks to Ana above for the helpful tip about leaving display value as null. <br /><br />I struggled as well for a while before I looked at the comments.<br /><br />Kudos to Dimitri for this very helpful post.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-87944490584626710192011-07-22T20:43:18.739+02:002011-07-22T20:43:18.739+02:00Dimitri, the shuttle is perfect and you have a gre...Dimitri, the shuttle is perfect and you have a great explanation of how to use them. My requirement is to populate the existing values. I can do this with most fields using a dynamic action. I can’t seem to get this to work for a shuttle or select list where I have multiple values. Any help would be appreciated.John C Smithhttps://www.blogger.com/profile/13993970725160975224noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-57880067971419341742010-10-14T22:36:49.610+02:002010-10-14T22:36:49.610+02:00Hi Patrick,
I'd like to know how to get the ...Hi Patrick, <br /><br />I'd like to know how to get the values in the shuttle.<br /><br /><br />Thank you.<br /><br />Tiago VTiago Vhttps://www.blogger.com/profile/06578321391367815352noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-2131674584880398672010-01-23T15:38:46.751+01:002010-01-23T15:38:46.751+01:00Hello,
I start with APEX, I would like to know how...Hello,<br />I start with APEX, I would like to know how I can do to filter a query report to the selected items in a shuttle. For example:<br />SELECT a, b, c FROM table WHERE c in (: P_ITEM_SHUTTLE)MOTIGAhttps://www.blogger.com/profile/08118610132881240256noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-36032398806477129232009-10-08T05:53:24.240+02:002009-10-08T05:53:24.240+02:00Hey Dimitri,
i figer out that defauly value one......Hey Dimitri,<br />i figer out that defauly value one...<br /><br />Now can u pls let me know that like in a report builder we have lexical parameter same can we have in APEX too?<br /><br />thanks!<br />uditUdit kr Jainhttps://www.blogger.com/profile/10670480598982571952noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-5157359203717725232009-10-07T13:41:27.804+02:002009-10-07T13:41:27.804+02:00Hello Dimitri,
You have a really wonderful blog. ...Hello Dimitri,<br /><br />You have a really wonderful blog. I am new to APEX...i m trying to have a default value for a select list LOV...My lov is a dynamic one.... can i achieved that?<br /><br />Pls let me know, how?<br /><br />Thanks!<br /><br />UditUdit kr Jainhttps://www.blogger.com/profile/10670480598982571952noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-89240026711217244192009-07-24T17:01:40.163+02:002009-07-24T17:01:40.163+02:00Don't forget to set the Shuttle properties pro...Don't forget to set the Shuttle properties properly. In LOV, set 'Display Extra Values' to YES.<br /><br />For the life of me I couldn't figure out why mine wasn't working. It was just because of the little thing.Carinahttps://www.blogger.com/profile/11267317353104448657noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-65043763935001628522009-05-29T05:23:41.650+02:002009-05-29T05:23:41.650+02:00Dimitri,
I'm new to APEX. I'm trying to use shuttl...Dimitri,<br />I'm new to APEX. I'm trying to use shuttle box in my application. The situation is as given below. Left side of shuttle box should be populated by a query and the right side of the shuttle box should be populated from a different query. I should be able to shuttle between both the boxes. Is it possible? If you could throw some light on it, it would be really helful. Thanks!<br /><br />ShaanAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-60399130082990684812008-01-22T17:00:00.000+01:002008-01-22T17:00:00.000+01:00Hi Patrick,Sure you can use another method to assi...Hi Patrick,<BR/><BR/>Sure you can use another method to assign the values. I guess it depends case by case; when to use a computation (and what type of computation), when to use a process, with or without conditions, when to use the source value/expression ...<BR/><BR/>As I said in my post: so many ways to get the same result ;-)<BR/><BR/>DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-70712338478753275742008-01-22T00:43:00.000+01:002008-01-22T00:43:00.000+01:00Dimitri, very useful tip! From what I have read on...Dimitri, very useful tip! From what I have read on the forum a lot of people have problems understanding the Shuttle/Multi-Select-Lists/Checkboxes and how to set them.<BR/><BR/>BTW, wouldn't it be better to use the "Source value or expression" property of the Shuttle? Because if the computation is defined as "Before Header", it will be executed each time the the page is rendered...<BR/><BR/>PatrickPatrick Wolfhttps://www.blogger.com/profile/16652802762749621200noreply@blogger.com