Skip to Main Content

New version of htmldbQuery jQuery plugins sample application for Oracle Application Express 3.2

Even APEX 3.2 is old version now, I have fixed few bugs from htmldbQuery jQuery plugin. Sample application has been updated to use latest jQuery and includes few more samples how to use htmldbQuery plugin.

In sample application page 23 you can find new sample for cascading LOV in tabular form. I have used not so well known APEX_UTIL functions SAVEKEY_VC2 and KEYVAL_VC2.

Check that out, it might help you also when working in newer version of APEX.

Download sample application

Comments

  • mjfigur 28-JUL-11 09.38.43.000000 PM
    Thank you so much. Will work on writing another function to enable both.
  • Jari Laine 28-JUL-11 09.35.49.000000 PM

    Hi,

    What I did check, you need write own function for cascading combobox plugin.

    Regards,
    Jari

  • mjfigur 28-JUL-11 08.42.59.000000 PM
    thank you this works great when tried against page 22. Would it work as well with page 20 and the refreshemp function?
  • Jari Laine 28-JUL-11 08.05.51.000000 AM

    Hi,

    What I quickly test, below should work. 

    $(function(){
     $("#P22_EMPLOYEE_NAME").htmldbCascade(
      "#P22_MANAGER_NAME",
      "EMPLOYEE_CASCADE_ALL_LOV",{
      parentSession :true,
      nullShow      :true,
      nullDisplay   :"- Select -",
      nullValue     :"0"
     }).combobox().change(function(){$(this).hide()});
    });
    

    Of course it is better modify plugin and have e.g. own function for this purpose.

    Regards,
    Jari

  • mjfigur 28-JUL-11 04.04.42.000000 AM
    Jari, Thank you for all of your work on this sample application. I was wondering if it is possible to combine the combobox with the cascading select lists? I currently have the cascading select lists working well but just cannot figure out how to make them a combobox and cascade at the same time. Thanks in advance Matt