How to customize the filter component for OracleADFtable Columns

Lt; f: facetnamefiltergt; lt; af: selectOneChoicerequired # {bindings. Pay0detailVO1. hints. V

Lt; f: facet name = filtergt; lt; af: selectOneChoice required = # {bindings. Pay0detailVO1. hints. V

Normally dragged af: the query area of the filtering row of the table component is only the text input field.

:,

However, if the design requirement is to edit the new row, if some columns are in the form of search help or drop-down box, text filtering in the filtering area will not get the desired result.

:

When you filter the code column in the settlement direction, you cannot filter out the desired results by simply entering the added payment because the data in each row comes from the dictionary items in the database.

In addition, the value stored in this column is the dictionary item code, and the dictionary item name is displayed on the UI. therefore, you can only obtain the desired result by entering the data dictionary Code such as 01 02 03 during filtering.

However, you do not know the dictionary code.

Then, in the filtering area, read the database dictionary items in the drop-down box to filter the items.

The operation is as follows: Go to the pagedefine. xml page.

Add a drop-down List:

Select the second select one value list that update a base data source

Then select model driven List to find the LOV of this field.

The code generated in XML is as follows. If you are skilled, COPY the Code directly.

[Html]

Users is the name of the LOV used. Which table does IterBinding use for iteration?

After the page definition file is complete, you can draw a filter drop-down box on the page. The column field has the f: facet name = "filter" attribute.

Usage:

[Plain]

Here, the value is bound to the field required by vs. filterCriteria;

Why?

The filtering area will be selected, but the blank space will not be returned;

So add f: selectItem and itemvalue = "" Before f: selectItems ""

This is an example of the drop-down box for implementing the custom filter component.

,