Hi, When I select a value in LOV, the page is submitted and the shuttle is sorted. I want to get results in the shuttle when I select a value in LOV without submit page. I tried with dynamic action to refresh the shuttle item. But, I didn't get any value on the right side of the shuttle. Thanks in advance!
Vinish Kapoor
Hi Pavlos, You mean, you have a LOV item and a shuttle item, and when you are selecting a value from LOV, you want selection automatically from the shuttle?
I am a little confused; it will be better if you can share the screenshot and try to point out in that screenshot, then it will be easy to understand.
Also, what do you mean by sorting the shuttle? Please clear.
Thanks.
pavlos
Hi Vinish!
Sorry for the bad explanation. I have LOV item and Shuttle item, LOV is parent item of the shuttle. When I choose a value from the LOV page is submitted(with DA) and the shuttle item is sorted appropriately(assigned values on the right side).
I want to refresh the shuttle item when I choose a value in LOV without submit page. I tried with DA to refresh the shuttle item but, after every refresh, all values in shuttle are in the left side.
I get results in shuttle only when the page is submitted.
If my explanation is still confusing I'll create demo 🙂
Vinish Kapoor
OK, now I understand fully. Thanks.
You can create a DA on LOV to set value for the shuttle item. Below are the steps:
I have one item for LOV P33_LOV and a shuttle item P33_SHUTTLE.
Create a dynamic action on LOV item to set the value of the shuttle as following:
Set Type: SQL Statement
SQL: select :P33_SHUTTLE || ':' || :P33_LOV from dual
Items to Submit: P33_LOV,P33_SHUTTLE
Affected elements: P33_SHUTTLE
Below is the screenshot of the above setting:
I have tested and it is working fine for me.
Please test and let me know if you have any issues.
pavlos
I followed your steps, but there is still nothing on the right side of the shuttle when I choose a value in LOV item. when I manually reload the page, values in the shuttle is sorted well.
LOV item looks different than yours, I use two regions one for LOV and one for the shuttle. LOV is a select list (dropdown menu).
Vinish Kapoor
Source SQL query for both the items should be same. Even dropdown is working, you please check if you missing something.
pavlos
LOV item is a different table than the shuttle, I think that I can't use the same SQL for both.
Vinish Kapoor
But the returned value is the same, right? If the returned value is the same it should have no issues.
And having different regions also not an issue.
Can you share it in the dummy app, as you shared previously? I will check then.
pavlos
I've created a demo app.
Workspace: apex1, user: testuser123, pass: Apex123456
Vinish Kapoor
I have modified the app, I found some extra settings that is why it was conflicting.
I have removed the cascade LOV item from the shuttle because in the shuttle query you are not referring to the LOV item.
For LOV, I changed the action type to none, previously it was set as Submit page. Also, changed the query to show order id instead of the username.
For the set value, I have specified as PL/SQL expression and it will set the value for the shuttle for the currently selected, if you want to append every new selection to the shuttle then you can use the SQL query I specified in the first example.
After login to your app, I was asked to the changed password so the new password is: pav12345
Please check and let me know.
pavlos
I notice that this way I can only get one value on the right side of the shuttle. I tried with your first DA example, but it didn't work.
In demo app, some values in LOV should return more than one value.
Vinish Kapoor
Ok, it means that the shuttle depends on the above LOV item.
And if an Order ID is selected from LOV, then all items/rates should appear at the right side of the shuttle.
Then, in this case, the shuttle should have the cascade item set.
Let me know if I am correct; then I will modify the app again.
pavlos
Yes, shuttle value depends on item value and all values should be in the right side for selected Order Id
pavlos
Works now, thanks a lot Vinish!
Vinish Kapoor
Hi Pavlos,
I modified the demo app, please check again and let me know. Thanks.
pavlos
Thanks a lot, Vinish!
Works now but, I want to keep unassigned values in the left side, that I can manage with them.
Vinish Kapoor
Ok let me check the app again.
Vinish Kapoor
Now please check again.
pavlos
Thanks a lot Vinish, works now 🙂
Chetana
I am facing same issue . I want to know which settings done in app.
Vinish Kapoor
Please ask your question using the Ask Question button and give more details about your issue.