selectOneChoice table filter for LOV column
来源:互联网 发布:易石软件客服 编辑:程序博客网 时间:2024/06/04 18:34
In this post I am going to show how to add a selectOneChoice component as a filter for a column with LOV.
When displaying data into tables and using the out-of-the-box filtering feature, you might want for a column with list of values attribute to also have that list of values in the filter section.
The demo application is built on hr schema and considered we have already built the Model project with business components for Employees and Departments, and the EmployeesVO has a LOV on DepartmentId attribute.
In the ViewController project we then create a new jspx page, employees.jspx and add the employees table from DataControl -> EmployeesVO with Filtering option checked.
To add the data model behind the selectOneChoice filter we intend to put into the department column, we select the Bindings tab for employees page and add a new binding in the Bindings box. Select ‘tree’ in the next window of the create binding wizzard and then fill in the data as in the following screenshot:
In the Source tab of employee page, we add the filter facet for the department column (lines 5-14):
<
af:column
sortProperty
=
"DepartmentId"
filterable
=
"true"
sortable
=
"false"
headerText
=
"#{bindings.EmployeesVO.hints.DepartmentId.label}"
id
=
"c4"
width
=
"150"
>
<
f:facet
name
=
"filter"
>
<
af:selectOneChoice
value
=
"#{vs.filterCriteria.DepartmentId}"
label
=
"Dep"
unselectedLabel
=
""
id
=
"soc2"
>
<
af:forEach
items
=
"#{bindings.DepartmentsVO.rangeSet}"
var
=
"item"
>
<
f:selectItem
id
=
"si2"
itemLabel
=
"#{item.DepartmentName}"
itemValue
=
"#{item.DepartmentId}"
/>
</
af:forEach
>
</
af:selectOneChoice
>
</
f:facet
>
<
af:selectOneChoice
value
=
"#{row.bindings.DepartmentId.inputValue}"
label
=
"#{row.bindings.DepartmentId.label}"
required
=
"#{bindings.EmployeesVO.hints.DepartmentId.mandatory}"
shortDesc
=
"#{bindings.EmployeesVO.hints.DepartmentId.tooltip}"
id
=
"soc1"
>
<
f:selectItems
value
=
"#{row.bindings.DepartmentId.items}"
id
=
"si1"
/>
</
af:selectOneChoice
>
</
af:column
>
- selectOneChoice table filter for LOV column
- LOV for Editable Primary Key in ADF Table Problem
- adf oracle selectOneChoice 加 LOV 后手动设置Lov的值
- Using table loop for filter
- Reading table information for completion of table and column names
- Sybase Precision for the Float type of table's column
- Indexing NULL table column values for fast SQL performance
- Indexing NULL table column values for fast SQL performance
- LOV
- ORA-22913: must specify table name for nested table column or attribute
- Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
- 解决:Reading table information for completion of table and column names
- Primary Key Importance for LOV View Object
- Workaround for LOV on Primary Key Attribute
- 搞定Fixed Column Table
- TABLE CONTROL 隐藏column
- salesforce table column sort
- cassandra column family table
- Windows命令
- struts2 实现文件上传和下载
- 继承中构造函数和析构函数地调用顺序
- 黑马程序员--Semaphore(信号灯)
- 计算机核心期刊、学报一览
- selectOneChoice table filter for LOV column
- app.config连接数据库的配置
- C++ 写入注册表
- Sqlserver 2008 备份数据库语句
- python-markdown用法
- maven 依赖打包
- C++和操作系统面试问题分类
- 基于xmpp openfire smack开发之smack类库介绍和使用[2]
- 唐骏曾经的语录