Thursday, July 28, 2016

Dependent MessageChoice in OAF Table Region

Dependent Pick List VO query like:

select unique UOM_CODE lookup_code ,xx_code from xx.xx_tbl
where xx_code = :1

In Controller PR method:

    OAAdvancedTableBean  tableBean

      (OAAdvancedTableBean)oawebbean.findIndexedChildRecursive("ConstAreaDtlsTable");
        OAMessageChoiceBean k = (OAMessageChoiceBean)oawebbean.findIndexedChildRecursive("choiceList");
        k.setListVOBoundContainerColumn(0, tableBean,"DepColvalue1");
        k.setListVOBoundContainerColumn(1, tableBean,"DepColvalue2");
        k.setPickListCacheEnabled(false);                 

//  "DepColvalue1","DepColvalue2" are the Item ID in the page Structure and the choice list query execute based on these values for each row in Table Region Dynamically.
       

Some Examples for above:

OAMessageChoiceBean k1 = (OAMessageChoiceBean)oawebbean.findIndexedChildRecursive(“Applicable1″);
k1.setListVOBoundContainerColumn(0, tableBean2,”ProgramId1″);
k1.setListVOBoundContainerColumn(1, tableBean2,”ConstareaId”);
// k1.setListVOBoundContainerColumn(1, tableBean2,”SaleableareaId”);
k1.setPickListCacheEnabled(false);

OAMessageChoiceBean k3 = (OAMessageChoiceBean)oawebbean.findIndexedChildRecursive(“BudgetCodeFlexValue”);
k3.setListVOBoundContainerColumn(0, tableBean,”BudCodeFlex”);
k3.setPickListCacheEnabled(false);

OAMessageChoiceBean k4 = (OAMessageChoiceBean)oawebbean.findIndexedChildRecursive(“BudgetCodeFlexValue1″);
k4.setListVOBoundContainerColumn(0, tableBean2,”BudCodeFlex1”);
k4.setPickListCacheEnabled(false);

No comments:

Post a Comment