Shay Shmeltzer's Oracle Development Tools Tips

Finding a code by typing the description and autosuggest

Shay Shmeltzer
Director of Product Management - Oracle

A while back I created a blog/demo that showed how easy it is to get the translation of a code field to show up in ADF forms by using a join based VO on two entities and partial trigger on the code field.

I got an interesting question on the comments for that entry that asked whether I can do the reverse and allow the user to type the description of a field and get the code based on the description. Well it turns out that is not that complex either. Throw in the ease of implementing auto-suggest behavior with ADF BC and ADF Faces and you got a very nice solution for that question.

See here:

Join the discussion

Comments ( 1 )
  • guest Saturday, December 3, 2011

    Hey Shay,

    i'd like to implement the description autosuggest item in a table column.

    There is one problem in my example i've encountered, it is about current row binding. The new values set by autosuggest item are set to the whole column's rows (department column in your demo). Could you hint at how to fix that?

    Best regards,


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.