1. IG 컬럼 >> Advanced
JavaScript Initialization Code :
function( config ) {
config.defaultGridColumnOptions = {
defaultValue: function () {
return {d:"관리자", v: "21"};
}
}
return config;
}
이렇게 하지 않고 보통 다른 컬럼들 하는 것처럼 default 값을 셋팅하게 되면 value 는 셋팅이 되지만 Display 값은 셋팅되지 않아서 위와 같이 json 형식으로 셋팅하면 됨
참고
https://hardlikesoftware.com/weblog/2017/03/31/how-to-hack-apex-interactive-grid-part-4/
https://www.jmjcloud.com/blog/workaround-for-issue-setting-a-default-value-for-the-apex-192-popup-lov
https://community.oracle.com/tech/developers/discussion/4335748/how-to-set-default-value-for-popup-lov
https://docs.oracle.com/en/database/oracle/application-express/21.2/aexjs/model.html#.FieldMeta
config.initActions = function(actions) {
var addRow = actions.lookup("selection-add-row");
var originalAction = addRow.action;
addRow.action = function(event,el) {
originalAction(event,el);
setTimeout(function() {
apex.item("P17_ENAME").setFocus();
}, 100);
return true;
}
}
function( config ) {
config.defaultGridColumnOptions = {
defaultValue: function( model, record ) {
return ...;
}
}
return config;
}
var val,
model = this.data.model,
rec = this.data.record,
meta = model.getRecordMetadata(this.data.recordId);
if ( meta.inserted ) {
val = model.getValue(rec, "JOB")
if ( val.v === val.d ) {
model.setValue(rec,"JOB", {d:apex.item("C_JOB").displayValueFor("CLERK"), v: "CLERK"});
}
val = model.getValue(rec, "ONLEAVE");
if ( val.v === val.d ) {
model.setValue(rec,"ONLEAVE", {d:apex.item("C_ONLEAVE").displayValueFor("N"), v:"N"});
}
}
function(config) {
config.defaultGridColumnOptions = {
defaultValue: function( model, srcRecord ) {
let m,
name = "";
if ( srcRecord ) {
name = model.getValue( srcRecord, "ENAME" ),
m = /(.*)(\d+)$/.exec( name );
if ( m ) {
name = m[1] + ( parseInt( m[2], 10 ) + 1 );
} else {
name += "_1";
}
}
return name;
}
}
return config;
}
