This is a migrated thread and some comments may be shown as answers.

filter radgridview with different values [on hold]

1 Answer 29 Views
GridView
This is a migrated thread and some comments may be shown as answers.
alejandro
Top achievements
Rank 1
alejandro asked on 16 Apr 2018, 10:09 AM

I have the following radgridview. In the alert column the filter takes out a 0 or a 1, which is the data that is collected from the database.

How could I change 0 for no alert and 1 for alert?

Thank you very much

 

<telerik:RadGridView Name="rgvExplorador"                                         
                                GridLinesVisibility="Both"                                            
                                GroupPanelBackground="LightGray"
                                GroupPanelForeground="Black"                                
                                ShowSearchPanel="True"
                                ShowGroupPanel="False"                                     
                                d:LayoutOverrides="Height"
                                Grid.Row="1"
                                FontSize="10.667"
                                CanUserResizeColumns="False"
                                CanUserFreezeColumns="False"
                                AutoGenerateColumns="False"
                                SelectionMode="Single"
                                ItemsSource="{Binding}"
                                RowIndicatorVisibility="Collapsed" >
               <telerik:RadGridView.GroupDescriptors>
 
                   <telerik:GroupDescriptor Member="areaTexto" SortDirection="Ascending" />
                   <telerik:GroupDescriptor Member="clasificacionTexto" SortDirection="Ascending" />
 
               </telerik:RadGridView.GroupDescriptors>
 
               <telerik:RadGridView.Columns>
 
                   <telerik:GridViewDataColumn  Header="Área" DataMemberBinding="{Binding areaTexto}"  Width="70" IsReadOnly="True"  IsGroupable="True" IsVisible="False"/>
                   <telerik:GridViewDataColumn  Header="Clasificación" DataMemberBinding="{Binding clasificacionTexto}"  Width="140" IsReadOnly="True"  IsGroupable="True" IsVisible="False"/>
 
                   <telerik:GridViewDataColumn Header="Título" DataMemberBinding="{Binding descripcion}" IsReadOnly="True" TextWrapping="Wrap" Width="300">
                       <telerik:GridViewColumn.ToolTipTemplate>
                           <DataTemplate>
                               <StackPanel Orientation="Vertical" Width="300"  MinHeight="80"  Background="White">
                                   <TextBlock Text="Descripción:" FontWeight="Bold"/>
                                   <TextBlock Text="{Binding Objetivo}" TextWrapping="Wrap"/>
                               </StackPanel>
                           </DataTemplate>
                       </telerik:GridViewColumn.ToolTipTemplate>
                   </telerik:GridViewDataColumn>
 
                   <telerik:GridViewDataColumn Header="Nº" DataMemberBinding="{Binding IdAlerta}" IsReadOnly="True" Width="auto"  IsGroupable="True"/>
                   <telerik:GridViewDataColumn x:Name="colHV" Header="Info dimensional" DataMemberBinding="{Binding HvInfoDesc}" IsReadOnly="True" />
                   <telerik:GridViewDataColumn x:Name="colPatron" Header="Patrón" DataMemberBinding="{Binding HF_Referencia}" IsReadOnly="True" />
                   <telerik:GridViewDataColumn Header="Período" DataMemberBinding="{Binding FechaDatos}" DataFormatString="{}{0:MMM/yyyy}"  Width="70" IsReadOnly="True"/>
                   <telerik:GridViewDataColumn Header="Entidad" DataMemberBinding="{Binding Entidad}" IsReadOnly="True"  Width="70" />
                   <telerik:GridViewDataColumn IsReadOnly="True" Width="30"  DataMemberBinding="{Binding EsAlerta}" IsGroupable="True" ShowDistinctFilters="True" >
 
                       <telerik:GridViewDataColumn.CellTemplate>
                           <DataTemplate>
                               <Image>
                                   <Image.Style>
                                       <Style TargetType="{x:Type Image}">
                                           <Setter Property="Source" Value="/Mercvrio.Style;component/Images/Blank.png" />
                                           <Style.Triggers>
                                               <DataTrigger Value="1" Binding="{Binding EsAlerta}">
                                                   <Setter Property="Source" Value="/Mercvrio.Style;component/Images/WarningRed.png"/>
                                               </DataTrigger>
                                               <DataTrigger Value="1" Binding="{Binding AlertaPositiva}">
                                                   <Setter Property="Source" Value="/Mercvrio.Style;component/Images/Warning.png"/>
                                               </DataTrigger>
                                               <DataTrigger Value="0" Binding="{Binding EsAlerta}">
                                                   <Setter Property="Source" Value="/Mercvrio.Style;component/Images/Blank.png"/>
                                               </DataTrigger>
 
                                           </Style.Triggers>
                                       </Style>
                                   </Image.Style>
                               </Image>
                           </DataTemplate>
                       </telerik:GridViewDataColumn.CellTemplate>
                   </telerik:GridViewDataColumn>

1 Answer, 1 is accepted

Sort by
0
Stefan
Telerik team
answered on 18 Apr 2018, 03:48 PM
Hello Alejandro,

Thanks for the code snippet provided.

A possible solution for your requirement would be to apply an IValueConverter for the DataMemberBinding of the needed column. Note, that such an approach would only affect the presentation of the DistinctValues of the FilteringControl. The actual data operation would be applied over the raw data values. Would such an approach be working for you? You may find the Applied IValueConverter on the DataMemberBinding article useful on this matter.

Regards,
Stefan
Progress Telerik
Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
Tags
GridView
Asked by
alejandro
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Share this question
or