ADF View criteria Execution Modes

What are the different types of Execution Modes in ADF

There are 3 types Execution modes fro a view criteria that can be helpful in filtering out the data

1) Database: The search results are filtered from the Data base table every time the query is hit.

2) In Memory: The results are filtered from the VO cache memory. It will use the rows which are already in the row set. It will stop the unnecessary hits to the DB.

3) Both: The results are filtered from the existing row set and also from the filtered results from Database. This is useful when you want to filter from uncommitted records also.

Below scenario will explain the different types Execution Modes.

I have search criteria and result component as table to show the results. 

1) Execution Mode is DataBase in view criteria.

    There are 2 employees by the first name Steven. When we search for Steven it will show 2 records as          shown below.

I will add one more employee with the name Steven Gerrard, without saving i will search for Steven, it will show only 2 old employees.

2) Now changes the Execution Mode to 'Both' in the employee view criteria. Add new Record with the name Steven Gerrard, and do not commit the record into the DB, it will be in VO cache memory

3) Now search for Steven, it will show all the 3 Steven records. 2 from the DB and one from the VO cache memory as shown in below image.

ADF Tree table component

How to show the Master -child data in Tree structure in ADF.?

ADF provides one simple component by ADF Tree Table component, using this this component we can show the data in Tree structure.

Consider Employee Department relationship. We will show the list of employes for a department.

1) Create the view link between Department and employee, then you can see the viewlink AM Data Model.

First move the DepartmentVo to right side, and then move the View link under the DepartmentVo, it will look like below screen shot.

  
Now you can see this master-child relationship in the data-control.

2) Drag and drop the Deprtment table from the data-control to the jsff page as ADF Tree Table as shown below.

Once you drag and drop as ADF Tree Table, Add the Employee to the Department as shown below. At the beginning the Target Data Source is blank for both Department and Employee, we need to add the iterator into the bindings and then we need to add the Target Data Source.

3) Go to the Bindings and go to the Executables Add the iterator for the Child entity  ie Employee

4) Now go the bindings, edit the Department, and add the target Data Source using EL pIcker as shown in below image. Similarly add the Target Data Source for the Employee.

Now run the page and see the UI , you will see the Employee Name under each Department.

Switche the componenets between list of components in ADF

Switcher component is used to switch the components between the list of two or more components.

For example i have 2 Graphs(Bar Graph and Pie Chart) and i want to switch between the two graphs.

I have drop down with the with two options 1) Bar Graph 2) Pie Chart

By default Bar graph is shown, and when the user selects Pie chart, the corresponding chart will be shown.

First create drop down with the with two options, Bar Graph and Pie Chart

 <af:selectOneChoice label="Choose Graph" id="soc1"
                        binding="#{HeadersTableTaskFlowBean.chooseChart}"
                        autoSubmit="true">
      <af:selectItem label="Bar Graph" value="BarGraph"
                     id="si2"/>
      <af:selectItem label="Pie Chart" value="PieChart" id="si1"/>
    </af:selectOneChoice>


1) Add one Switcher component into the fragment, and insert two facet(f : facet) inside the Switcher, name each with the proper names.

2) Insert panelBox into the each facet. drag and drop the VO from the data control and create bar graph into the 1st panel box, and drag and drop the VO, create the pie chart into another panelBox.
    The Structure of the fragment looks like below image.

3) Go to the property inspector and select the DefaultFacet from the Drop down as shown in the below image.

4) Add Bindings to the Switcher components , it will create setter and getter methods in the managed bean, so that we can change the default Facet dynamically.

the below code gets create in the managed bean

  private UIXSwitcher graphSwitcher;

    public void setGraphSwitcher(UIXSwitcher graphSwitcher) {
        this.graphSwitcher = graphSwitcher;
    }

    public UIXSwitcher getGraphSwitcher() {
        return graphSwitcher;
    }

 

4) Add valueChangeListener to the selectOneChoice, in the same managed bean.

 <af:selectOneChoice label="Choose Graph" id="soc1"
                        binding="#{HeadersTableTaskFlowBean.chooseChart}"
                        autoSubmit="true"
                        valueChangeListener="#{HeadersTableTaskFlowBean.changeGraphs}">

 changeGraphs is the method created in the managed bean.  In the valueChangeListener method get the new value from the drop down, set the defaultfacet and Facetname, and add the partial triggers.
 
 Below is the code 

 public void changeGraphs(ValueChangeEvent graph) {
        // Add event code here...
        String str = (String)graph.getNewValue();
        this.graphSwitcher.setDefaultFacet(str);
        this.graphSwitcher.setFacetName(str);
        AdfFacesContext ctx = AdfFacesContext.getCurrentInstance();
        ctx.addPartialTarget(graphSwitcher);      
    }

By default it will show the bar graph, as we have choosen the defaultFacet as BarGraph

And when we select the pie Chart from the drop down, it will show the pie chart.

How to generated default values for the PK's

If we want to generate the default values for the PK's, there are many options to do that. I will show in 2 ways to generate the PK's


1) Open the Entity Object, and select the unique option and Primary Key option as show in the below image
It will generate the Random numbers, starting from 1.

2) If you want to generate the numbers sequentially not randomly, use sequences. Follow below steps to generate default values for PK using sequences.

i) Go to the SQL Developer, expand the DB and right click on the Sequncee to create new sequence as in shown below image.

ii) In the opened sequence pop-up, specify the values as you want . Press OK to complete.

iii) Now create a trigger fro the sequence which you have created.

CREATE OR REPLACE TRIGGER department_pk
       BEFORE INSERT
        ON Department
              FOR EACH ROW
                  BEGIN
                        SELECT SAMPLE_SEQ.nextval
                        INTO :new.Department_id
                  FROM dual;
                  END;


department_pk is the trigger name, Department is the table name , SAMPLE_SEQ is the sequence we have created. Department_id is the PK column name

iv) Now go to the Entity Object. open the attribute, and select the data type as DBSequence, then you can see the option to enter the Sequence name which you have created at the DB side. Enter the DB sequence name and press Ok.

And you can start using it.

Conditional based Enabling and Disabling the fields in ADF

I have requirement to make the Text field as enable and disable based on the results of the other fields.

I have drop down with the values, and text box side to it. In ADF for LOV's we cannot enter the user inputs.

Below image describes the UI which i want.

 

When i select the any of the Environment, the text box needs to be disabled, when i select the blank value, the text need to be enable to enter the use inputs.

 We can achieve this by below steps.

1) Go the binding property of the textField, and bind it to the Bean class. In the bean class Setters and getters methods gets create

Textfield Code in jsff

  <af:inputText label="" id="it2"
                disabled="#{bindings.StringValue1.inputValue != ''}"
                binding="#{backingBeanScope.SampleBean.hostNameText}"/>
        </af:panelFormLayout>

  Bean class Code after binding the textfield.

   private RichInputText hostNameText;

    public RichInputText getHostNameText() {
        return hostNameText;
    }
    public void setHostNameText(RichInputText hostNameText) {
        this.hostNameText= hostNameText;
    }

2) Add the ValueChangeListner in the SelectOneChoice , I am giving the method name as refreshHostname

jsff Code 

<af:selectOneChoice value="#{bindings.StringValue1.inputValue}"
                              label="Environment"
                              required="#{bindings.StringValue1.hints.mandatory}"
                              shortDesc="#{bindings.StringValue1.hints.tooltip}"
                              id="soc8"
                              valueChangeListener="#{backingBeanScope.SampleBean.refreshHostname}"
                              autoSubmit="true">
            <f:selectItems value="#{bindings.StringValue1.items}" id="si8" />
          </af:selectOneChoice>

Note: Make sure that autoSubmit is set true, otherwise the value change listener will not be called

3) In the Bean method, add the code for partial triggers.

  Bean method code.

    public void refreshHostname(ValueChangeEvent valueChangeEvent) {
        // Add event code here...

       // Evaluate the bindings before fetching the SelectOneChoice value
        ADFUtil.setEL("#{bindings.StringValue1.inputValue}",valueChangeEvent.getNewValue());
        AdfFacesContext ctx = AdfFacesContext.getCurrentInstance();
        BindingContext bctx = BindingContext.getCurrent();
        String temp = valueChangeEvent.getNewValue().toString();
        BindingContainer bindings = bctx.getCurrentBindingsEntry();
        AttributeBinding hostNameBinding =                (AttributeBinding)bindings.getControlBinding("StringValue1");
        hostName = hostNameBinding.getInputValue().toString();
        if(hostName == null || hostName == ""){
            hostNameText.setDisabled(false);
            hostNameText.setRendered(true);
            ctx.addPartialTarget(hostNameText);
        }else{
            hostNameText.setDisabled(true);
            ctx.addPartialTarget(hostNameText);
        }
    }

ADFUtil Evaluate code to Evaluate the bindings.

    public static void setEL(String el, Object val) {
        FacesContext facesContext = FacesContext.getCurrentInstance();
        ELContext elContext = facesContext.getELContext();
        ExpressionFactory expressionFactory =
            facesContext.getApplication().getExpressionFactory();
        ValueExpression exp =
            expressionFactory.createValueExpression(elContext, el,
                                                    Object.class);

        exp.setValue(elContext, val);
    }

Please Note that: Before fetching the SelectOneChoice value in the bean method.

Evaluate the Bindings of the SelectOneChoice to fetch the latest value selected, otherwise you will end up with the previous value selected from the dropdown.

How to get all the selected rows from a table in ADF.

How get all the selected rows from the UI ADF table.

For example you want to print all the departments which you have selected in the UI..
 
1. In the Table property inspector make rowSelection="multiple". And
Go to the Binding in Advanced option. Select the managed bean (or create new managed Bean) where you want to access this this Table. And create new property. (just give one new name)

Like below it will generate the code in the managed bean for the RichTable.

   private RichTable departmentTable;

   public void setDepartmentTable(RichTable departmentTable) {
        this.departmentTable = departmentTable;
    }
    public RichTable getDepartmentTable() {
        return departmentTable;
    }

2. Now you can access the selected rows from the table using below code.

RowKeySet selectedRowKeySet = this.getDepartmentTable().getSelectedRowKeys();
System.out.println("Number of rows:"+ selectedRowKeySet.size());

Using "selectedRowKeySet" you can iterate and get all the department data by rowwise

You can write this code in the SelctionListner of the Table itself so that if you want to perform any operations on selction of rows. as shown below.

FacesContext fc =FacesContext.getCurrentInstance();
RowKeySet selectedRowKeySet = this.getDepartmentTable().getSelectedRowKeys();
       
ExpressionFactory ef = fc.getApplication().getExpressionFactory();
 MethodExpression me = ef.createMethodExpression(fc.getELContext(),       "#{bindings.DepartmentVO1.collectionModel.makeCurrent}", null,
                                                     new Class[] { SelectionEvent.class });
        me.invoke(fc.getELContext(), new Object[] { selectionEvent });
        System.out.println("Number of rows:"+ selectedRowKeySet.size());

This works properly even if you have the dependent fragments. Like if you have Employee fragment depend on Departments selection.


The image is shown below where you have selected multiple rows.

How to show the pop-up by programmatically

Recently i was working one feature in ADF, where i wanted to show the pop-up programmatically.  I searched in the net but could'nt find the proper solution. So thought of posting this solution.


You can display the pop-up easily using <af:showPopupBehavior triggerType="action" popupId=":::p2"/>.
But in some situation if you want to do through Managed bean, follow the below procedure.

1. Add the popup component to your jsff (fragment page) with the dialog box in it, with the whatever message you want.


2. In the managed bean instantiate an Object of RichPopup with the setters and getters method, Below is the Managed bean code fragment for showing the Popup.

 public class ShowPopUp{
    private RichPopup richpopupId;
   
    public void setRichpopupId(RichPopup richpopupId) {
        this.richpopupId = richpopupId;
    }

    public RichPopup getRichpopupId() {
        return richpopupId;

  public void showPopup(){

  String popupId="p1";
  FacesContext context = FacesContext.getCurrentInstance();
  StringBuilder script = new StringBuilder();
  ExtendedRenderKitService extRenderKitSrvc = Service.getRenderKitService(context,            ExtendedRenderKitService.class);
  script.append("var popup = AdfPage.PAGE.findComponent('"+popupId+ "'); ").append("popup.show();");
  extRenderKitSrvc.addScript(context, script.toString());

}
}
 
In the above code String popupId="p1"; , p1 is the Id of the popup which you have added in 1st step.

3. Now go to the popup in the structure window of the jsff page, then go to the Advanced option in the Property inspector. In the Binding bind it to the "richpopupId" of the managed bean.