Oracle Knowledge Street

Why should I change the Column Width of a Popup LOV when I have an option to stretch it to view the whole content? Let me explain this with a use case: Customer: I want to display a three columns in my Popup LOV and the first column must be fully visible. Akil: There is an option to stretch the column to view its whole content. Customer: No, I want it to be displayed fully. I don't want to stretch the column manually. Akil: Ok, I can make this possible! Let's Start.... 1) Create an Item in the page (In this example: P16_EMP_NAME). 2) Create the list of values that will display the multiple columns in the Popup LOV. I created four columns in my Popup LOV. Refer below screenshot. To know how to display multiple columns in a Popup LOV, see  Karkuvel Raja's Post   3) Paste the below JavaScript code in the J avaScript Initialization Code section of the Popup LOV item (P16_EMP_NAME). function(options) { var col, columns = options.columns; col = col...

Popup LOV is the most common LOV type used in Oracle APEX. This blog explains how to get the Display and Return value of a Popup LOV using java script. 1) Create a Popup LOV item (In this example they are P1_COUNTRY_LOV ) 2) Create two page items to store the captured display and return values.     (In this example they are  P1_COUNTRY_DISPLAYVAL ,  P1_COUNTRY_RETURNVAL ) 3)  Create a Dynamic action          Event:  Change         Selection Type:  Item         Item:  P1_COUNTRY_LOV 4) Create a True Action      Action:  Execute JavaScript Code      Paste the below code: //to get the return value of the popup lov let returnVal = apex.item("P1_COUNTRY_LOV").getValue(); //to get the display value of the popup lov let displayVal = document.getElementById("P1_COUNTRY_LOV").value; //to set the captured value to page Items (for using the captured ...