In ADF table if you enable column filter this filter by default will search by "start with" and it will be case sensitive . For example in table employees if you have employee name = Hermann and you try to search by "man", the search will return no result
but if you search by "Herm" it will return result
If you try to search by "herm" it will return no result.
This is because the filter by default is case sensitive and will search by start with.
In many cases we need the all tables filters be case insensitive and search by contains not start with. You can search by case insensitive by setting filterFeatures="caseInsensitive" for each af:column but you need to do this in all af:column in your application and it will not be a proper solution.
You can search with contains by typing your string between '%', but we need something to be more easy than typing %.
To make the the ADF table filter be case insensitive and search by contains follow these steps:
1- In model project create new class "CustomViewImpl" this class should extend oracle.jbo.server.ViewObjectImpl
2- In this class override getCriteriaItemClause(ViewCriteriaItem viewCriteriaItem) and write this code:
| public String getCriteriaItemClause(ViewCriteriaItem viewCriteriaItem) |
| { |
| if (viewCriteriaItem.getAttributeDef().getJavaType().getName().equals("java.lang.String")) |
| { |
| viewCriteriaItem.setValue("%" + viewCriteriaItem.getValue() + "%"); |
| } |
| viewCriteriaItem.setUpperColumns(true); |
| return super.getCriteriaItemClause(viewCriteriaItem); |
| } |
3- Go to Model --> Project Properties --> ADF Business Components --> Base Classes --> View Object --> change Object to point to your CustomViewImpl class
4- Open ViewObject --> Java --> Java Classes --> Generate View Object Class
5- If you open the generated ViewImpl class you will find it extend the CustomViewImpl class
6- Run the application and test.
custom generic class in model level
import oracle.jbo.ViewCriteriaItem;
import oracle.jbo.server.ViewObjectImpl;
public class CustomViewImpl extends ViewObjectImpl {
/**
* Added for filtering data in Grid using filters.
* */
@Override
public String getCriteriaItemClause(ViewCriteriaItem viewCriteriaItem) {
if (!viewCriteriaItem.getValue().toString().startsWith(":")) {
if (viewCriteriaItem.getValue() != null &&
viewCriteriaItem.getAttributeDef().getJavaType().getName().equals("java.lang.String")) {
viewCriteriaItem.setValue("%" + viewCriteriaItem.getValue()+ "%");
}
}
viewCriteriaItem.setUpperColumns(true);
return super.getCriteriaItemClause(viewCriteriaItem);
}
}
-- --- this method need to write at voimpl class
public String getCriteriaItemClause(ViewCriteriaItem viewCriteriaItem) {
System.out.println("--- one");
String vl=(String)viewCriteriaItem.getValue();
System.out.println("--- get value : "+ viewCriteriaItem.getValue()+" val : "+vl);
if(viewCriteriaItem.getValue()!=null && !viewCriteriaItem.getValue().toString().startsWith(":")){
System.out.println("-- start with :");
if(viewCriteriaItem.getValue()!=null && viewCriteriaItem.getAttributeDef().getJavaType().getName().equals("java.lang.String")){
viewCriteriaItem.setValue("%" + viewCriteriaItem.getValue());
}
}
viewCriteriaItem.setUpperColumns(true);
return super.getCriteriaItemClause(viewCriteriaItem);
}
--- this is another way
We have default sorting and filtering options in adf table. But table filters are case sensitive by default. If we need to make the filters as case insensitive, we have simple option with properties. We no need to write any custom code to achieve this.
In properties we have filterFeatures attribute. For that we need to declare “caseInsensitive” like below :
Thats all. We got the case insensitive for adf table filters .
