8 Replies Latest reply: Nov 4, 2009 12:16 PM by User639232-Oracle RSS

    Date popup problem in APEX 3.1

    585759
      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
          joelkallman-Oracle
          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
            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
              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
                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
                  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
                    Thank you
                    I copied your file and works gr8.
                    thanks for you help
                    • 7. Re: Date popup problem in APEX 3.1
                      696272
                      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-Oracle
                        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