Banner 9: able run form in local but not in server. On server error is Not not authorized access Form

Banner 9: able run form in local but not in server. On server error is Not not authorized access Form


Check all security and GUAPAGE too

*ERROR* User HRBATUSR not authorized access form in Banner 9

Banner error not authorized access GOAIMMU

Banner error not authorized to access GUAINIT

Banner: Cache issues when using Tomcat 8.x in an Eclipse development environment

Banner: Cache issues when using Tomcat 8.x in an Eclipse development environment

Testing Banner 9.x admin pages in an Eclipse development with Tomcat 8.x can result in problems with page data being cached.  Due to known Eclipse bugs, the "Serve modules without publishing" flag must be unchecked or Tomcat 8.x will not start up.  With that flag unchecked, users have reported annoying cache issues with changes not being picked up when testing.  Sometimes clearing the web browser cache manually or doing Tomcat -> Clean and Tomcat -> Clean Tomcat Work Directory will fix the issue, but not always.  The suggested work around is to switch to Tomcat 7.x for all testing done via Eclipse.  Once development work has been finished, the extensions and custom pages can later be deployed on a Tomcat 8.x server (outside of Eclipse) if desired.

Banner: Eclipse caching old code

Banner 9: Eclipse caching old code

solution:

- close  eclipse
- open eclipse
- refresh project
- refresh Webservice. HR
- maven update clean project

sometime need to to twice

Banner 9: Add Where clause into SQL query runtime

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+"' ");
  }
 


}

Banner 9: Fix tab issue

Banner 9: Fix tab issue

Solution:

Add NextItem into structure file and items should be same block

ex

<Item CanvasName="FFRMASF_4_CANVAS" Id="FFRMASF_ACTV_CODE_LBT" MaxLength="4" Navigable="false" Type="Button" NextItem="FFRMASF_AMT" />


OR

@ActionTrigger(action="KEY-NEXT-ITEM", item="LOCN_CODE_RESP", function=KeyFunction.NEXT_ITEM)
public void ffbmastLocnCodeResp_keyNexItem()
{

goBlock("xxxx");
goItem(toStr("ROOM_NUM"));
getTask().getGoqrpls().gCheckFailure();

}

Banner 9: LOV box and LOV dialog

Banner 9: LOV box and LOV dialog

Create LOV, ValueSet RG

Banner 9: Hide Save button

Banner 9: Hide Save button


- Extend save button first

- Then hide it