Skip to main content

ADF Table Filter Customization


This is to explain how a query listener on an af:table component is used to intercept
table queries so the developer can programmatically modify the query conditions
provided by the application user.e.g. when using the table filter.

Default query by ADF for filtering the result contains a map having parameters which are there in the table and their respective value's.

In a page you have a table filters enabled. And if you want to override the filter query through bean use the following code.

import java.util.Map;
import javax.el.ELContext;
import javax.el.ExpressionFactory;
import javax.el.MethodExpression;
import javax.faces.context.FacesContext;
import oracle.adf.view.rich.event.QueryEvent;
import oracle.adf.view.rich.model.FilterableQueryDescriptor;

public class BackingBean {
    public BackingBean() {
    }
    public void customQueryListner(QueryEvent queryEvent) {
        // Add event code here...
        try {
            FilterableQueryDescriptor fqd =(FilterableQueryDescriptor)queryEvent.getDescriptor();
            Map map = fqd.getFilterCriteria();
            String Type = (String)map.get("Type");
            if (Type.length() != 0) {
                Type = "%" + Type;
                map.remove("Type");
                map.put("Type", Type);
                fqd.setFilterCriteria(map);
            }
           
            this.invokeMethodExpression("#{bindings.ClaimsRVO1Query.processQuery}",Object.class, QueryEvent.class,queryEvent);
        } catch (Exception e) {
            // TODO: Add catch code
            e.printStackTrace();
        } }
    public Object invokeMethodExpression( String expr, Class returnType, Class[] argTypes,Object[] args){
     FacesContext fc = FacesContext.getCurrentInstance();
     ELContext elctx = fc.getELContext();
     ExpressionFactory elFactory = fc.getApplication().getExpressionFactory();
     MethodExpression methodExpr = elFactory.createMethodExpression(elctx, expr, returnType, argTypes);
     return methodExpr.invoke(elctx,args);
    
     }
    public Object invokeMethodExpression(String expr, Class returnType, Class argType, Object argument){
     return invokeMethodExpression(expr, returnType,new Class[]{argType}, new Object[]{argument});
     }
}



in your existing class you can use only three methods which will resolve your problem.

1. customQueryListner -  It is the query listner which you call from page
(queryListener="#{backingBeanScope.BackingBean.customQueryListner}")

2.invokeMethodExpression() which again calls one overrriden mwthod  invokeMethodExpression()


 

Comments

Popular posts from this blog

The file store "WLS_DIAGNOSTICS" could not be opened

WLS_DIAGNOSTIC ERROR weblogic.store.PersistentStoreException: [Store:280073]The file store "WLS_DIAGNOSTICS" could not be opened because it contained a file with the invalid version 1. A file of version 2 was expected. When you get this error while running your application on internal weblogic server delete the following file WLS_DIAGNOSTICS000000.DAT search the file in following path C:\jdev_work\system11.1.1.5.37.60.13\DefaultDomain this file is in DefaultDomain folder of your jdev. and delete the WLS_DIAGNOSTICS000000.DAT file . and run your applicatuon

Passivation and Activation in ADF (Application Module )

1. For performance reasons, ADF keeps a pool of application modules in memory. It tries to give each session the same application module as the session used during the last request; however, this might not be possible during peak load of your application. 2. In this case, ADF saves the application modules state in a database table so the application module can be used by another session. This is called passivation . 3. When the first session needs the application module again, its state is retrieved from the database process known as activation . 4. If you have made an error in your code and depend on some variable that is not persisted correctly when your application module state is stored, you will experience mysterious errors under high load.   Enable/Disable Application Module Pooling : Right-click on your application module, choose Configurations.By default, each application module has two configurations. Ensure that the one ending in …Local is selected and then c...

Overview Editor for bc4j.xcfg

This is used to customize the configuration settings for the application pool, connection pool, and transactions. Select the Application Module, then select a configuration from the Configurations list. You can specify a Default Configuration from the dropdown to use with selected application module. Edit the name of the configuration in Details. Its having 3 tabs 1.Database and Scalability 2. Properties 3. Custom Properties Database and Scalability Tab : In Database and Scalability you can mention the JDBC data source definition for each application module. You can choose to connect to a JDBC data source or to a JDBC URL.The default connection type is the default data source. A data source is a vendor-independent encapsulation of a database server connection on the application server. 1. Data sources ( JNDI name) offer advantages over a JDBC URL connection because the data source can be tuned, reconfigured, or remapped without changing the deployed application. 2. JDB...