ADF ViewCritera is basically used to create where clause in ViewObjects.
Suppose you have created a ViewObject with a selected statement and you want that data to be filtered by where clause, in this case, ViewCritera comes into the picture.
Let us see how we can create a ViewCriteria.
Click on Add Button to create a ViewCriteria.
Now click on Add Item button to add a clause to View Criteria.
Here I want a filter the Department table with the DepartmentVO with DepartmentId as 10. So I have selected value 10. So the ViewCriteria is created now.
I have added an instance DepartmentVO2 to apply the above viewCritera and check.
Now click on the Edit Button. and select the ViewCritera.
Now click on the Ok button. So the ViewCriteria is applied now.
Run the application module to see the results.
As you can see the buttons are grayed out, which means there is only one record in the view. The records are filtered on the basis of given criteria.
RowQualifier can also be used for in-memory filtering of the rows.
Filtering rows through RowQualifier in ADF
Suppose you have created a ViewObject with a selected statement and you want that data to be filtered by where clause, in this case, ViewCritera comes into the picture.
Click on Add Button to create a ViewCriteria.
Now click on Add Item button to add a clause to View Criteria.
Here I want a filter the Department table with the DepartmentVO with DepartmentId as 10. So I have selected value 10. So the ViewCriteria is created now.
I have added an instance DepartmentVO2 to apply the above viewCritera and check.
Now click on the Edit Button. and select the ViewCritera.
Now click on the Ok button. So the ViewCriteria is applied now.
Run the application module to see the results.
As you can see the buttons are grayed out, which means there is only one record in the view. The records are filtered on the basis of given criteria.
RowQualifier can also be used for in-memory filtering of the rows.
Filtering rows through RowQualifier in ADF
No comments:
Post a Comment