Getting value from table filter in ADF

Scenario: In many case we may need to override the default filter of af:table. Here I am going to show you how you can override the default table filter and getting the entered values from table filter along with attribute names.

Solution : Suppose you have a af:table which is build on EmployeesVO. Now go to you table source code in jspx/jsff and override the default queryListener and create a binding of your table to your bean as shown below:

 <af:table value="#{bindings.EmployeesVO1.collectionModel}" var="row"
                    rows="#{bindings.EmployeesVO1.rangeSize}"
                    emptyText="#{bindings.EmployeesVO1.viewable ? 'No data to display.' : 'Access Denied.'}"
                    fetchSize="#{bindings.EmployeesVO1.rangeSize}"
                    rowBandingInterval="0"
                    filterModel="#{bindings.EmployeesVO1Query.queryDescriptor}"
                    queryListener="#{backingBeanScope.TableFilterTestBean.queryTable}"
                    filterVisible="true" varStatus="vs"
                    selectionListener="#{bindings.EmployeesVO1.collectionModel.makeCurrent}"
                    rowSelection="multiple" id="t1" styleClass="AFStretchWidth"
                    columnStretching="last" contentDelivery="immediate"
                    binding="#{backingBeanScope.TableFilterTestBean.employeeTable}">

Now go to your bean and write the following code inside your bean as shown below:

    public void queryTable(QueryEvent queryEvent) {
        FilterableQueryDescriptor filterQueryDes =
            (FilterableQueryDescriptor)employeeTable.getFilterModel();
        Map filterCriteria = filterQueryDes.getFilterCriteria();
        Iterator it = filterCriteria.entrySet().iterator();
        while (it.hasNext()) {
            Map.Entry pair = (Map.Entry)it.next();
            System.out.println("Attribute Name====>" + pair.getKey() + "    " +
                               "Attribute Value======>" + pair.getValue());
        }
        invokeQueryEventMethodExpression("#{bindings.EmployeesVO1Query.processQuery}",queryEvent);
    }

    private void invokeQueryEventMethodExpression(
        String expression, QueryEvent queryEvent) {
        FacesContext fctx = FacesContext.getCurrentInstance();
        ELContext elctx = fctx.getELContext();
        ExpressionFactory efactory =fctx.getApplication().getExpressionFactory();
        MethodExpression me =efactory.createMethodExpression(elctx, expression, Object.class, new Class[] { QueryEvent.class });
        me.invoke(elctx, new Object[] { queryEvent });


    }
    private RichTable employeeTable;
    public void setEmployeeTable(RichTable employeeTable) {
        this.employeeTable = employeeTable;
    }

    public RichTable getEmployeeTable() {
        return employeeTable;
    }

Now run your page and enter some value in table filter as shown below:

and click on enter. You will get all your value which you have entered in filter and if there is corresponding result you will get that filtered result in your table also.

In console you can see your output as follows:

Attribute Name====>ManagerId        Attribute Value======>20
Attribute Name====>Email            Attribute Value======>SKING
Attribute Name====>JobId            Attribute Value======>AD_RES
Attribute Name====>HireDate         Attribute Value======>Tue Jun 17 00:00:00 IST 2003
Attribute Name====>Salary           Attribute Value======>24000
Attribute Name====>FirstName        Attribute Value======>Steven
Attribute Name====>PhoneNumber      Attribute Value======>515.123.4567
Attribute Name====>CommissionPct    Attribute Value======>0.5
Attribute Name====>DepartmentId     Attribute Value======>90
Attribute Name====>LastName         Attribute Value======>King
Attribute Name====>EmployeeId       Attribute Value======>100

Happy coding :)


Comments

Post a Comment

Popular posts from this blog

Setting up the environment for Angular2 and Hello World Example in Angular2

Image
Hi All, In this post I am going you to show you how you can set up the environment for Angular2. You may want to run your application in different servers. So here I am going to show you how you can run your Angular2 application in the following two servers: 1. lite-server (static server) 2. Weblogic Server 10.3 Lets do the setup for lite server.  First of all go to any directory in your computer and create a folder in that directory with name "angular2-example". You can do it by the command line also by typing the following command. mkdir  angular2-example Now once the directory is created you need to create three files. 1. tsconfig.json 2. typings.json 3. package.json 1.  tsconfig.json This file is TypeScript compiler configuration file. It guides the compiler to generate JavaScript files after compilation. The content of this file will be as follows: {   "compilerOptions": {     "target": "es6",     "modu...
Read more

Showing number of rows or row count on top and bottom of table in ADF.

Image
Hi Friends, We will see today how to show the page count on top and bottom of table in ADF. I am assuming that you all know how to create the table to show data from view object in ADF. Assume you have a table which contains the information of employees from employees table of HR schema. Now surround this table with a panel collection. Now your panel collection has some facet with name "statusbar", "toolbar" etc. Right click on facet "toolbar" and select "insert after f : facet toolbar and then "Facet Secondary Toolbar" as shown below in image. Now on facet "statusbar" and "secondaryToolbar" put toolbar component from component pallet. Then put a output text inside each toolbar as follows:  <f:facet name="secondaryToolbar">             <af:toolbar id="t3" stretchId="s2">               <af:spacer width="10" height="10" id="s2...
Read more

Build a Simple ReactJS application using react-cli

Image
Hi All, In this blog we will see how we can create a sample application using react-cli.  It is a command line interface tool that seeks to automate some tasks when working on a React.js project. To starts with you have to install it globally by running following command: npm install -g react-cli The you have to run the following command in command window: npm install -g create-react-app  Now once it is installed you can create any directory where you want to create you sample ReactJS application. I have created a folder with name "TestApp" in my local drive. Now you have to run the following command to create the sample application. create-react-app testapp  While it is creating application and downloading all the artifacts related to this you can see the following things in command line as shown below: So it will create a ReactJS application with name "testapp" under folder "TestApp" as you can see in the above screenshot. On...
Read more