How to filter shuttle list for a given word in Oracle Apex?

1
votes

I have a shuttle list in Oracle Apex with list of over 500 values so it's very difficult to get the required value so I want to keep a search bar above the shuttle list and search a word that returns contained text (from search bar) in the shuttle list.

2
oracleoracle-apex

2 Answers

0
votes

Check this plugin:

https://apex.world/ords/f?p=100:710:12202826165752::::P710_PLG_ID:NL.DETORA.APEX.RESTRICT_SHUTTLE_VAUES

If you have questions about how to set it up, do not hesitate to ask.

4
votes

Here's how:

  • create a text item, let's name it :P1_SEARCH
  • set "Submit when enter pressed" property to "Yes"

  • modify shuttle item's query by adding a WHERE clause (or additional condition, if it already exists) as

    where some_column like '%' || :P1_SEARCH ||'%'

[EDIT]

If submitting the page fires validations (which you don't have to happen at the moment), then

  • set "Submit when enter pressed" back to "No"
  • go to shuttle item's properties
  • set "Cascading LOV Parent Item(s)" to P1_SEARCH