Using Filters with Comboboxes

[Unknown]

I have a GridDataVisibleColumn with the MappingName="IssuerId".

 

<sf:GridDataVisibleColumn HeaderText="Issuer" MappingName="IssuerId" IsReadOnly="False" Width="125" >
     <sf:GridDataVisibleColumn.HeaderStyle>
         <sf:GridDataColumnStyle HorizontalAlignment="Center"/>
     </sf:GridDataVisibleColumn.HeaderStyle>
     <sf:GridDataVisibleColumn.ColumnStyle>
         <sf:GridDataColumnStyle CellType="ComboBox" DropDownStyle="AutoComplete"/>
     </sf:GridDataVisibleColumn.ColumnStyle>
 </sf:GridDataVisibleColumn>

 

 

In Code Behind I hook up the ItemsSource to my View Model list; DisplayMember, & ValueMember.

 

 this.grdImportBlotter.VisibleColumns["IssuerId"].ColumnStyle.ItemsSource = this.vm.Issuers;
 this.grdImportBlotter.VisibleColumns["IssuerId"].ColumnStyle.DisplayMember = "DealName";
 this.grdImportBlotter.VisibleColumns["IssuerId"].ColumnStyle.ValueMember = "DealId";

When I try to filter this column, the list that the user can filter on is a list of, what appears to be the ValueMember, rather than the DisplayMember.

How can I get the filter control to show the Name (DisplayMember) rather than the ValueMember (which is a Guid)?

Thanks.

[Jai Ganesh S]

Hi Andrew,

 

We are sorry for the delay.

 

We have analyzed your query. You can get the filter control based on DisplayMember by setting the “CanFormatExcelLikeFilterText “API as true in the GridDataVisibleColumn. Please find the code snippet to illustrate this,

 

Code Snippet [XAML]:

 

<syncfusion:GridDataVisibleColumn HeaderText="Issuer" CanFormatExcelLikeFilterText="True" MappingName="IssuerId" IsReadOnly="False" Width="125" >

 

      <syncfusion:GridDataVisibleColumn.HeaderStyle>

           <syncfusion:GridDataColumnStyle HorizontalAlignment="Center"/>

      </syncfusion:GridDataVisibleColumn.HeaderStyle>

 

      <syncfusion:GridDataVisibleColumn.ColumnStyle>

           <syncfusion:GridDataColumnStyle CellType="ComboBox" DropDownStyle="AutoComplete"/>

      </syncfusion:GridDataVisibleColumn.ColumnStyle>

 

</syncfusion:GridDataVisibleColumn>

 

Please let us know if you need further assistance.

 

Thank you,

Jai Ganesh S