Archive for category ADF

ViewCriteria setOperator


private void filterallItems(Number gnlRoleSpecId) {
GnlRoleSpecROVOImpl GnlRoleSpecROVO = (GnlRoleSpecROVOImpl)CommonOperations.getView("GnlRoleSpecROVOIterator");
ViewCriteria gnlRoleSpecROViewCriteria = GnlRoleSpecROVO.createViewCriteria();
ViewCriteriaRow gnlRoleSpecROViewCriteriaRow = gnlRoleSpecROViewCriteria.createViewCriteriaRow();
gnlRoleSpecROViewCriteriaRow.setAttribute("GnlRoleSpecId", gnlRoleSpecId);
gnlRoleSpecROViewCriteria.add(gnlRoleSpecROViewCriteriaRow);
gnlRoleSpecROViewCriteriaRow.setOperator("GnlRoleSpecId", "");
GnlRoleSpecROVO.applyViewCriteria(gnlRoleSpecROViewCriteria);
GnlRoleSpecROVO.getQuery();
GnlRoleSpecROVO.executeQuery();

}

SELECT * FROM (SELECT GnlRoleSpec.GNL_ROLE_SPEC_ID,
GnlRoleSpec.NAME,
GnlRoleSpec.DESCR,
GnlRoleSpec.RSRC_KEY,
GnlRoleSpec.APLCB_RULE_ID,
GnlRoleSpec.APLCB_RULE_EXPR,
GnlRoleSpec.IS_GOV_ADDR,
GnlRoleSpec.OWNER_ID,
GnlRoleSpec.CDATE,
GnlRoleSpec.CUSER,
GnlRoleSpec.UDATE,
GnlRoleSpec.UUSER,
GnlRoleSpec.IS_GOV_OWNER,
GnlRoleSpec.SHRT_CODE,
GnlRoleSpec.IS_ACTV
FROM GNL_ROLE_SPEC GnlRoleSpec) QRSLT WHERE ( ( (GNL_ROLE_SPEC_ID 8071 ) ) )

Leave a comment

How to set Bind Variable Values at runtime ?

ViewObject vo = am.findViewObject(“EmployeesView1”);
vo.setNamedWhereClauseParam(“bindVarDeptId”, new Number(10));
vo.executeQuery();

Leave a comment

combo currentRow

jsf
…:selectOneChoice value=”#{bindings.GeneralGnpTpLOV.inputValue}”


GeneralGnpTpLOVRowImpl gnlGnpTpLovRow =
(GeneralGnpTpLOVRowImpl)JSFUtils.resolveExpression("#{bindings.GeneralGnpTpLOV.currentRow}");

Leave a comment