Click Event in IG-Selector

圖片
 IG 勾選時,條件符合下不能勾選 Dynamic Action  When  Event : Click  Selection Type : jQuery Selector jQuery Selector : .u-selector Advanced Event Scope : Dynamic    var $te = $(this.triggeringElement); var rowId = $te.closest('tr').data('id'); //Primary Key var ig$ = apex.region("region_static_id").widget(); var model = ig$.interactiveGrid("getViews", "grid").model; var record = model.getRecord(rowId); var a = model.getValue( record, "AAA"); //column name : AAA var b = model.getValue( record, "BBB"); //column name : BBB /* apex.item( "Px_AAA" ).setValue (a); apex.item( "Px_BBB" ).setValue (b); */ if (a === b) { $(this.triggeringElement).removeClass("is-selected"); } #About : Primary Key

Quickly get data from AJAX

Example : 
1. Create "Ajax Callback" , name: get_emp
apex_util.json_from_sql('with e as 
                        (
                        select empno,ename,job,mgr,hiredate,sal from emp
                        )
                        select emp.* , mgr.ename mgr_name from e emp , e mgr
                        where emp.mgr = mgr.empno(+)
                        and emp.empno = :P135_EMPNO
                        ');

2. Create "Dynamic Action" in LOV 
    Action : Execute Javascript Code
apex.server.process
  ("get_emp"
  ,{ 
    pageItems : '#P135_EMPNO'
   }
  ,{ 
    success:function(pData)
    {
        $s('P135_JOB', pData.row[0].JOB);
        $s('P135_MGR', pData.row[0].MGR_NAME);       
        $s('P135_HIREDATE',new Date(pData.row[0].HIREDATE).toLocaleDateString());
        $s('P135_SAL', pData.row[0].SAL);
       
     }
} );

留言

這個網誌中的熱門文章

AJAX & Lottie Animation