This discussion is archived
8 Replies Latest reply: Nov 4, 2009 10:16 AM by user639232 RSS

Date popup problem in APEX 3.1

585759 Newbie
Currently Being Moderated
Hi

I have a date picker (DD-MM-YYYY HH24:MI) and after upgrading to APEX 3.1 from APEX 3.0.1 the popup window height is too small.

The end user is having to resize the window to click on the OK button.

Is there a file I can edit to increase the height, couldnt find it in templates/themes.

Regards
Adam
  • 1. Re: Date popup problem in APEX 3.1
    jkallman Employee ACE
    Currently Being Moderated
    Hi Adam,

    This is a bug in APEX 3.1. It was discussed here:

    Apex 3.1 Upgrade Issue - dba_lock and date picker display

    and here:

    Date Picker problem in Apex 3.1

    I'll let Carl investigate and provide an official response and recommendation. Although I know where this problem is occurring.

    The size of the popup calendar window is hard-wired in the file apex/images/javascript/apex_3_1.js. In APEX 3.0, the size of the popup window was determined programatically at runtime and was a function of the date format, if it included a time component or not.

    The uncompressed, readable version of this same file is in apex/images/javascript/uncompressed/apex_3_1.js. Look for p_DatePicker and you'll see what I'm talking about. You'll see the height is hard-wired to 210 and width to 258. In APEX 3.0, the height was set to 255 if the date format contained a time component.

    So my suggestion, until Carl provides an official response, is to look for '210' in apex/images/javascript/apex_3_1.js and change this to 255. Granted, all calendar popup windows will be this big, but it won't put as great a burden on the end-user.

    I hope this helps.

    Joel
  • 2. Re: Date popup problem in APEX 3.1
    357241 Oracle ACE
    Currently Being Moderated
    Hello,

    Well it is a bug, and we will be releasing a fix with the first patch. You can fix the issue per Joel's instructions or I have provided a edited and compressed apex_3_1.js file here

    http://apex.oracle.com/i/carl/unofficial/apex_3_1.js

    which can replace the file in /i/javascript/apex_3_1.js

    You could almost say that the fix contained in this file is almost exactly the same as the fix that will be in the patch , but this is an unsupported file and using it gives you an unsupported APEX instance , so please make sure to keep a copy of the old one in case you need to call support.

    We will not be updating the apex_3_1.js file on apex.oracle.com at the moment.


    Regards,
    Carl

    blog : http://carlback.blogspot.com//
    apex examples : http://apex.oracle.com/pls/otn/f?p=11933:5
  • 3. Re: Date popup problem in APEX 3.1
    Arie Geller Guru
    Currently Being Moderated
    Hello Carl,

    For consistency purposes (and some learning on my part), can you please provide also the un-compressed version of this JS file?

    BTW, what software are you using to compress the JS code?

    Thanks,
    Arie.
  • 4. Re: Date popup problem in APEX 3.1
    357241 Oracle ACE
    Currently Being Moderated
    Hello,

    >>
    For consistency purposes (and some learning on my part), can you please provide also the un-compressed version of this JS file?
    >>

    At the moment I'm a bit leary of doing that, it will be included in the official patch though, all I have done is add a simple if statement to look if the hour and/or minute format was being passed if so adjust the height.

    >>
    BTW, what software are you using to compress the JS code?
    >>
    At the moment we are using the YUI Compressor http://developer.yahoo.com/yui/compressor/ though that might not always be the case

    You can test different libraries here http://compressorrater.thruhere.net/

    Regards,
    Carl

    blog : http://carlback.blogspot.com//
    apex examples : http://apex.oracle.com/pls/otn/f?p=11933:5
  • 5. Re: Date popup problem in APEX 3.1
    Arie Geller Guru
    Currently Being Moderated
    Hi Carl,

    >> all I have done is add a simple if statement to look if the hour and/or minute format was being passed if so adjust the height.

    Thanks. That is what I was trying to figure out.

    >> At the moment we are using the YUI Compressor http://developer.yahoo.com/yui/compressor/ though that might not always be the case

    Thanks for the info and the references. I’ll check them out.

    Regards,
    Arie.

    Message was edited by:
    ageller1
  • 6. Re: Date popup problem in APEX 3.1
    651781 Newbie
    Currently Being Moderated
    Thank you
    I copied your file and works gr8.
    thanks for you help
  • 7. Re: Date popup problem in APEX 3.1
    696272 Newbie
    Currently Being Moderated
    Hi can I also query something else ? how can we tweak the date picker to a certain timing say starting 9 am?

    thks
  • 8. Re: Date popup problem in APEX 3.1
    user639232 Newbie
    Currently Being Moderated
    Hi Joel,
    As mentioned in the thread, updating the apex_3_1.js file and loading the same still does not work. The date pickers still are misplaced.
    Any help would be really helpful.

    Thanks,
    Deepa