Single Article

Resizing interactive report column dropdown list

Category APEX and jQuery

Sometimes you might have problem that column value is long and do not show completely when you open IR column dropdown to filter with values.

For workaround you can add feature that end user can change dropdown width using jQuery resizable.

Add to page JavaScripts:

$(function(){
 $("#apexir_rollover").resizable({
  minWidth:$("#apexir_rollover").width(),
  handles:"e",
  start:function(e,u){
   document.body.onclick="";
  },stop:function(e,u){
   $(this).css({"height":""});
   setTimeout(function(){
    document.body.onclick=gReport.dialog.check;
   },100);
  }
 })
 .css({"z-index":9999})
 .children(".ui-resizable-e").css({"background":"#EFEFEF"});
});

Now when you click interactive report header and move mouse to dropdown edge, you can drag it wider.

Resizing dropdown link

Dropdown link

Updated 30.09.2011

If you have problems you can not resize dropdown, check your page template have doctype. See OTN forum thread: Interactive Reports - Width of column heading filter dialogue.

Comments

  • France 12-JUL-16

    I just want to thank you for your explanation ( well detailed ) helped me greatly .

        
  • a7md 12-FEB-13
    Hello, please how can i change the position of (column dropdown list) from left to right of column, Thank you.     
  • Jari Laine 12-FEB-13

    Hi Alexander26k,

    Sorry, but I have not had time check this.

    Have you check if there is ready plugin for this ?

    Regards, Jari

        
  • Alexander26k 11-FEB-13
    Hi. It's been a long time. I beg you if you can help with this task.     
  • Alexander26k 16-NOV-12
    I hope that you are able to do so in the coming days, because to me it is very necessary. Please help me     
  • Alexander26k 10-NOV-12
    Thank you very much! I hope that soon you will be able to do it. For me this is very important. Thank you again     
  • Jari Laine 10-NOV-12

    Hi Alexander26k,

    I might write blog post about column resizing. I'm currently quite busy so it might take while when I find time to do this.

    Regards, Jari

        
  • Alexander26k 09-NOV-12
    Can you help me did it? I do not understand how to do it.     
  • Jari Laine 09-NOV-12

    Hi Alexander26k,

    You mean resize interactive report columns? Yes, it should be possible if you write JavaScript code for that.

    Regards, Jari

        
  • Alexander26k 08-NOV-12
    Hello. Please tell me whether it is possible to make so that the user can resize columns themselves?     

Global Right Column

Archives

Subscribe in a Reader