This discussion is archived
8 Replies Latest reply: Mar 7, 2013 6:35 PM by MAXQIAN RSS

Skillbuilders - Super LOV plugin

MAXQIAN Newbie
Currently Being Moderated
Hi,

I am using Oracle APEX 4.2, I recently installed Skillbuilders - Super LOV plugin into my APEX instance. Everything worked fine.

But later, I used jQuery grid plugin to show the result. and somehow the Super LOV plugin doens't work.
The "Open Dialog" and "Clear Content" button disappeared.

What i have done is inclued the following files at the page edit page

Javascript
File URLs
http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js
http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/jquery-ui.min.js
/i/javascript/grid/pqgrid.min.js

CSS
File URLs
http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/themes/base/jquery-ui.css
/i/javascript/grid/pqgrid.min.css

Can someone help me with this? I think maybe there is a confliction between SuperLOV plugin and the jQuery grid plugin?
  • 1. Re: Skillbuilders - Super LOV plugin
    dmcghan Oracle ACE
    Currently Being Moderated
    Hi 991001,

    Looks like the CSS file you've added is overriding some of our CSS. If you put a demo on apex.oracle.com and provide us with developer credentials I'll take a look when I have time.

    Regards,
    Dan

    blog: http://DanielMcghan.us/
    work: http://SkillBuilders.com/APEX/
  • 2. Re: Skillbuilders - Super LOV plugin
    MAXQIAN Newbie
    Currently Being Moderated
    Hi, Dan,

    Thanks for your reply!

    please see the issue at the following:

    http://apex.oracle.com/pls/apex/f?p=73083:1

    You can use dan/123456 to login.

    Thanks,

    Max
  • 3. Re: Skillbuilders - Super LOV plugin
    Damir Vadas Newbie
    Currently Being Moderated
    Seems that clear button is not working in your case as well.

    Tried on Latest Chrome ...
  • 4. Re: Skillbuilders - Super LOV plugin
    MAXQIAN Newbie
    Currently Being Moderated
    Hi, Dan,

    After some test, i found out that if i remove the following 2 files:

    http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js
    http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/jquery-ui.min.js

    Then the plugin is working fine.

    the clear button does't work either, but since this is not a critial issue, i just ignored it. I just use the import function to install the plugin and didn't chage any default setting of this plugin.

    Your help is very much appreciated.

    Thanks,

    Max
  • 5. Re: Skillbuilders - Super LOV plugin
    dmcghan Oracle ACE
    Currently Being Moderated
    Hello,

    Max,

    I think you forgot to give me the workspace name. I want to be able to log in as a developer.

    Regards,
    Dan

    blog: http://DanielMcghan.us/
    work: http://SkillBuilders.com/APEX/Regards,
    Dan

    blog: http://DanielMcghan.us/
    work: http://SkillBuilders.com/APEX/
  • 6. Re: Skillbuilders - Super LOV plugin
    MAXQIAN Newbie
    Currently Being Moderated
    workspace name is HSU. sorrry i forgot it.
  • 7. Re: Skillbuilders - Super LOV plugin
    dmcghan Oracle ACE
    Currently Being Moderated
    Max,

    I took a quick look and confirmed your findings. There is a solution, but it's a little complex. I've modified your application to do the first part, which is to "safely" add a new version of jQuery and jQuery UI to APEX:
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
    <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/jquery-ui.min.js"></script>
    <script>
       var jQ_1_8_3 = jQuery.noConflict(true);
    
       (function($) {
          $(document).ready(function() {
             alert ('Look at me, new version with the old $ reference: ' + $.fn.jquery);
          });
       })(jQ_1_8_3);
    </script>
    The first 2 lines here bring in the new version of jQuery and then jQuery UI into the new jQuery object. The second part does two things. First, it uses noConflict to put the new version of jQuery in a custom variable named jQ_1_8_3 (while returning the previous value of jQuery and $ as they were). Second, I use "self-executing anonymous function/expression" to show you how you can still use the $ to refer to the new variable.

    Now, the next thing you would need to learn to do is to safely bring in the newer CSS file - that is if bringing it in now breaks something which may happen. That involves CSS scoping, which is an option you see when downloading jQuery UI (at the bottom): http://jqueryui.com/download/

    However, to do this, you would need to move to the file system and away from the hosted CDN files. I hope some of this makes sense...

    Regards,
    Dan

    blog: http://DanielMcghan.us/
    work: http://SkillBuilders.com/APEX/
  • 8. Re: Skillbuilders - Super LOV plugin
    MAXQIAN Newbie
    Currently Being Moderated
    Hi, Dan,

    Thanks very much for your information. But i am not quite an expert on javascript, so i haven't give it a try of your solution.
    Currently, we removed the PQGRID control, and use the standard report as a workaround.

    Thanks,

    Max

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points