Oracle Apex Additional Outputs & Popup LOVs Column Size Customize

 


Step 1 :

--> Create List of Value ( SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES )

--> Call Popup LOV  (FIRST_NAME)

--> Display As : Modal Dialog


Step 2 :

Set STATIC ID 

      LAST_NAME = LAST_NAME 
      SALARY =  SALARY 

(Same Name STATIC ID or Deferent Name you can use)


Step 3 :

Select LOV Item and set

Additional Outputs : LAST_NAME:LAST_NAME,SALARY:SALARY
(ITEM_NAME:STATIC_ID)

    IF 
Your Item is page Items then don't Need STATIC ID
Additional Outputs : LAST_NAME:P7_LAST_NAME,SALARY:P7_SALARY
(COLUMN_NAME:P7_ITEM_NAME)


Popup LOVs Column Size Customize
=======================

Select LOV Item and set

Initialization JavaScript Function :


//Javascript Codes

function(options) {

    var LAST_NAME, SALARY, columns = options.columns;


    // set a minimum width for the dialog

    options.minWidth = 500;


    // SALARY

    SALARY = columns.SALARY;

    SALARY.width = 80;

    SALARY.alignment = "right";

    SALARY.noStretch = true;


    // LAST_NAME

    LAST_NAME = columns.LAST_NAME;

    LAST_NAME.width = 100;

    LAST_NAME.alignment = "left";

    LAST_NAME.noStretch = true;

    return options;

}

Post a Comment

Previous Post Next Post