20210824 - 전화번호 포맷

1. JS 파일 업로드 (파일 다운로드는 하단 링크 참조)

Shared Components - Static Workspace Files

select rowid

     , user_mobile

     , replace(to_CHAR(user_mobile,'000,9999,9999'),',','-') user_mobile_vw

     , user_nm

     , role

  from x0822_users

var gridID = "myStaticIG";

var ig$    = apex.region(gridID).widget();

var grid   = ig$.interactiveGrid("getViews","grid");

var model  = ig$.interactiveGrid("getViews","grid").model;

var selectedRecords = grid.getSelectedRecords();

for (idx = 0; idx < selectedRecords.length; idx++) {

    record = model.getRecord(selectedRecords[idx][0]);

    model.setValue(record, 'USER_MOBILE', this.triggeringElement.value);

}

/* reference

  //insert new record on a model

  var myNewRecordId = model.insertNewRecord();

  console.log(record);

  console.log(model.getValue(record,"USER_NAME"));

*/

참고 : 

https://css-tricks.com/input-masking/

https://github.com/RobinHerbots/Inputmask