One of the new features of Early Adopter 2 are Cascading LOVs/Select Lists. I’m pretty sure that almost every APEX developer had already the requirement to refresh a child select list when a parent select list was changed. For example you pick a department in the first select list and the second should just show employees of that department. There are two solutions to solve that: Continue reading
Maybe you have already seen that I have released version 1.6 of the ApexLib Framework.
My original plan was to make the “Cascading lov” area feature complete in this release, but I was a little bit lazy on the weekend and was looking at some content management systems for the ApexLib Homepage, instead of doing some programming.
I have implemented a small improvement into my Generic solution for cascading lovs.
If you have a hierarchy of cascading lovs as I have it on my example page, the old version did an AJAX call for all cascading lovs and there cascading lovs, … each time a value was selected. But normally these calls will always result in an empty select list, because the value of the parent lov hasn’t been set yet.
I have done some minor enhancements and bug corrections for the ApexLib framework. It now supports Multiselect lovs, too. For details see the change log.
BTW, did you know that the Generic solution for cascading lovs, also works if the first item is a text item which restrict another lov?
I have updated the example on apex.oracle.com to include a multiselect lov and a lov which depends on a text item.
Change log of version v0.06 14-December-2006:
- Bug# 1615618: ApexLib_TabForm: error raised when no updateable report region exists.
Change log of version v0.05 14-December-2006
- CR# 1615591: ApexLib_Lov: add support for multiselect list.
I have updated the Generic solution for cascading lovs, it offers now supports for popup lovs, too.
I have also updated the example on apex.oracle.com to include a popup lov.
Change log of version 0.03 (12-December-2006):
- Added support for cascading popup lovs.
- Don’t generate a dependency if the referenced item issues a redirect/submit anyway.
- Corrected compilation errors in the ApexLib_Lov_for_flows_schema.pkb
Speed sometimes kills
Change log of version 0.04 (12-December-2006):
- Corrected a bug in the clearLovNullValues if called from the on-demand-process.
- Corrected wrong check in ApexLib.js.
Note: Before you read on, cascading LOVs are now natively implemented into APEX 4.0. See my related blog posting Oracle APEX 4.0: Cascading LOVs/Select Lists.