Banner 9: Add Where clause into SQL query runtime
@BeforeQuery
public void fzvacct_BeforeQuery(QueryEvent args) {
NString acctCode = this.getFormModel().getKeyBlock().getAcctCode();
if (acctCode != null && !acctCode.isEmpty()){
((IDBBusinessObject)args.getSource()).setWhereClause("ACCT_CODE = '"+acctCode+"' ");
}
}
Java, SpringBoot, React, Angular, Oracle, PL/SQL, Ellucian Banner, Puppet, Docker, Terraform technical notes
Subscribe to:
Post Comments (Atom)
AWS how to delete VPC when it has error with Network interface , Gateway decencies
how to delete VPC when it has error with Network interface , Gateway decencies in AWS 1. Check if it is running on EC2 instance then Sto...
-
ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1525 ORA-29261: bad argument ORA-29273: HTTP request failed ...
-
Banner 9 Admin: Invalid Object Name fix do steps: A record in GUBOBJS with a UI Version of D. • Records in GURAOBJ to define the defau...
-
chown root $ORACLE_HOME/bin/extjob chmod 4750 $ORACLE_HOME/bin/extjob chown root $ORACLE_HOME/rdbms/admin/externaljob.ora chmod 640 $ORA...
No comments:
Post a Comment