I have a List Grid with below Data.
Name, company Name, number.
Each Name is associated with different groups such as Group A, Group B, Group C.
If I include Group Name in the datasource(List grid data source) then I am able to get all the data duplicated because the same person is associated with more groups. The filter works fine here.
If i do not bring the groups in the datasource and do only with where clause then the filter does not work.
I tried with selectclause with distinct name , $defaultSelectClause. IT works fine for removing duplicate rows, but filtering does not work.
I got a warning saying === 2010-03-11 14:40:21,200 [l0-3] WARN SQLWhereClause - [builtinApplication.T_ATTRIBUTE_VALUE_MASTER_fetch] no column name for field named: GRP_TYPE_NAME
But I dont want to include the group name in the field list because it will bring duplicate names in the grid.
Name, company Name, number.
Each Name is associated with different groups such as Group A, Group B, Group C.
If I include Group Name in the datasource(List grid data source) then I am able to get all the data duplicated because the same person is associated with more groups. The filter works fine here.
If i do not bring the groups in the datasource and do only with where clause then the filter does not work.
I tried with selectclause with distinct name , $defaultSelectClause. IT works fine for removing duplicate rows, but filtering does not work.
I got a warning saying === 2010-03-11 14:40:21,200 [l0-3] WARN SQLWhereClause - [builtinApplication.T_ATTRIBUTE_VALUE_MASTER_fetch] no column name for field named: GRP_TYPE_NAME
But I dont want to include the group name in the field list because it will bring duplicate names in the grid.
Comment