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

Problem with filter

2 Answers 52 Views

Grid

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

Francesco Vivaldi asked on 05 Jul 2011, 08:36 AM

Hi,

i have a radgrid with filterbyColumn but if i insert the string "ok" in filter it doesn't work, other string works correctly

the problem is on "TaskResult" column.

mycode:

<telerik:RadGrid ID="SearchResult" runat="server" Culture="EN"

Width="1220px"

DataSourceID="odsTask"

ValidationSettings-EnableValidation="true" ValidationSettings-ValidationGroup="SearchResultGorup"

OnItemDataBound="SearchResult_ItemDataBound" OnItemCreated="SearchGrid_ItemCreated"

OnItemCommand="SearchResult_ItemCommand" >

<GroupingSettings CaseSensitive="false" />

<MasterTableView CommandItemDisplay="Top" AutoGenerateColumns="false" AllowSorting="True"

GridLines="None" AllowPaging="true" AllowFilteringByColumn="True" OverrideDataSourceControlSorting="true" DataSourceID="odsTask"

Width="1220px" NoMasterRecordsText="No Results Found"

DataKeyNames="IDTask,TaskGroup" CommandItemSettings-ShowAddNewRecordButton="false">

<CommandItemTemplate>

<div id="Command">

<asp:Label ID="lblTitleServer" SkinID="Title" runat="server" Text="<%$Resources:Resource, ListaTask %>" />

<telerik:RadButton ID="btAddNewServer" OnClick="btAddNewTask_Click" runat="server"

SkinID="ToolBarButtonRight" Text="<%$Resources:Resource, AddNewTask%>" Width="200px"

/>

</div>

</CommandItemTemplate>

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn DataField="IDTask" DataType="System.Int64"

FilterControlAltText="Filter IDTask column" HeaderText="ID" HeaderStyle-Width="20px" ItemStyle-Width="20px" FooterStyle-Width="20px" FilterControlWidth="20px"

SortExpression="IDTask" UniqueName="IDTask" ReadOnly="true" Visible="true" FilterImageUrl="../App_Themes/ICTTheme/immagini/u58.png"

AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Description" HeaderText="<%$Resources:Resource, TaskDescription %>" SortExpression="Description"

UniqueName="Description" Display="true" ItemStyle-Width="80px" HeaderStyle-Width="80px" FilterImageUrl="../App_Themes/ICTTheme/immagini/u58.png"

AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" DataType="System.String">

</telerik:GridBoundColumn>

<telerik:GridDropDownColumn DataField="UserIdentifier" DataSourceID="odsUsers"

HeaderStyle-Width="80px" ItemStyle-Width="80px" FooterStyle-Width="80px" FilterControlWidth="80px"

FilterControlAltText="Filter UserName column" HeaderText="<%$Resources:Resource, TaskAssignedUser %>" FilterImageUrl="../App_Themes/ICTTheme/immagini/u58.png"

ListTextField="UserName" ListValueField="UniqueIdentifier"

UniqueName="UserName" DataType="System.String"

AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

</telerik:GridDropDownColumn>

<telerik:GridBoundColumn DataField="UserName" HeaderText="UserName" SortExpression="UserName"

UniqueName="UserNameHidden" Display="false" ReadOnly="true" >

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn DataFormatString="{0:dd/MM/yyyy HH:mm}" PickerType="DateTimePicker" DataField="Data" DataType="System.DateTime"

HeaderStyle-Width="100px" ItemStyle-Width="100px" FooterStyle-Width="100px" FilterControlWidth="100px"

FilterControlAltText="Filter Data column" HeaderText="<%$Resources:Resource, DateTask %>" FilterImageUrl="../App_Themes/ICTTheme/immagini/u58.png"

SortExpression="Data" UniqueName="Data"

AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo">

</telerik:GridDateTimeColumn>

<telerik:GridTemplateColumn Display="false" DataField="Recurrent"

HeaderText="<%$Resources:Resource, Frequency %>"   SortExpression="Recurrent" FilterImageUrl="../App_Themes/ICTTheme/immagini/u58.png"

HeaderStyle-Width="30px" ItemStyle-Width="30px" FooterStyle-Width="30px" FilterControlWidth="30px" UniqueName="Recurrent" FilterListOptions="VaryByDataTypeAllowCustom" DataType="System.String"

AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

<ItemTemplate>

<%#Eval("RecurrentText") %>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox SelectedValue='<%#Bind("Recurrent") %>' runat="server" ID="cmbRecurrent" >

<Items>

<telerik:RadComboBoxItem Value="0" Text="no" Selected="true" />

<telerik:RadComboBoxItem Value="1" Text="yes" Selected="false" />

</Items>

</telerik:RadComboBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="RecurrentText" HeaderText="RecurrentText" SortExpression="RecurrentText"

UniqueName="RecurrentH" Display="false" ReadOnly="true" >

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn Display="false" UniqueName="Cadence" DataField="Cadence" HeaderText="Frequency" SortExpression="Cadence" FilterImageUrl="../App_Themes/ICTTheme/immagini/u58.png"

HeaderStyle-Width="30px" ItemStyle-Width="30px" FooterStyle-Width="30px" FilterControlWidth="30px"

AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

<ItemTemplate>

<%--<%#Eval("RecurrentTypeText") %> -

<%#Eval("Cadence") %>--%>

<%#Eval("CadenceAndRecurrentType") %>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox

SelectedValue='<%#Bind("RecurrentType") %>' ID="cmbCadency" runat="server" DataSourceID="odsCadency" DataTextField="Value" DataValueField="Key" /><

br />

<telerik:RadNumericTextBox runat="server" ID="txtCadency" Type="Number" DataType="Int32" dbValue='<%#Bind("Cadence") %>' >

<NumberFormat DecimalDigits="0" />

</telerik:RadNumericTextBox><br />

<asp:CustomValidator runat="server" ID="recurrentValidation" ControlToValidate="cmbRecurrent"

ErrorMessage="<%$Resources:Resource, MissCadency %>" ForeColor="Red" ValidationGroup="SearchResultGorup"

OnServerValidate="CadencyValidation" />

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn ReadOnly="true" Visible="false" Display="false" DataField="TaskGroup" />

<telerik:GridTemplateColumn Display="false" HeaderStyle-Width="30px" ItemStyle-Width="30px" FooterStyle-Width="30px" FilterControlWidth="30px"

UniqueName="CadenceExpiring" DataField="CadenceExpiring"

HeaderText="<%$Resources:Resource, CadenceExpiring %>" FilterImageUrl="../App_Themes/ICTTheme/immagini/u58.png"

AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo">

<ItemTemplate>

<%#String.Format("{0:dd/MM/yyyy}", Eval("CadenceExpiring"))%>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadDatePicker runat="server" ID="pckExpiringCadence" DbSelectedDate='<%#Bind("CadenceExpiring") %>' />

<asp:CustomValidator runat="server" ID="recurrentValidation2" ControlToValidate="cmbRecurrent" ValidateEmptyText="true"

ErrorMessage="<%$Resources:Resource, CedenceExpiringMissing %>" ForeColor="Red" ValidationGroup="SearchResultGorup"

OnServerValidate="UntilDateValidation" />

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="ResultDscr"

HeaderText="<%$Resources:Resource, TaskResult %>" SortExpression="ResultDscr" DataField="ResultDscr" FilterImageUrl="../App_Themes/ICTTheme/immagini/u58.png"

HeaderStyle-Width="30px" ItemStyle-Width="30px" FooterStyle-Width="30px" FilterControlWidth="30px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

<ItemTemplate>

<%#Resources.Resource.ResourceManager.GetString(Enum.GetName(typeof(TaskExtendedLogic.ResultEnum), Eval("Result")))%>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox runat="server" ID="ResultComboBox" DataSource="<%#GetValues()%>"

SelectedValue='<%#Bind("Result") %>' DataTextField="ResultName" DataValueField="ResultID" >

</telerik:RadComboBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<%---<telerik:GridBoundColumn DataField="Notes"

FilterControlAltText="Filter Notes column" HeaderText="Notes"

SortExpression="Notes" UniqueName="Notes">

</telerik:GridBoundColumn>---%>

<telerik:GridTemplateColumn HeaderText="Notes" SortExpression="Notes" UniqueName="Notes" FilterImageUrl="../App_Themes/ICTTheme/immagini/u58.png"

EditFormColumnIndex="1" DataField="Notes" Visible="false" ReadOnly="false">

<ItemTemplate>

<asp:Label runat="server" ID="Notes" Text='<%# Eval("Notes") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:CustomValidator runat="server" ID="NoteValidator" ControlToValidate="ResultComboBox" ValidateEmptyText="true"

ValidationGroup="SearchResultGorup" OnServerValidate="ValidateNote" ForeColor="Red" ErrorMessage="Please, write your notes below.">

</asp:CustomValidator> <br />

<asp:TextBox runat="server" Columns="20" Rows="5" TextMode="MultiLine" ID="Notes" Text='<%# Bind("Notes") %>'></asp:TextBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridButtonColumn CommandName="Edit" Text="Edit" UniqueName="EditColumn"

HeaderStyle-Width="20px" ItemStyle-Width="20px" FooterStyle-Width="20px" FilterControlWidth="20px"

ButtonType="ImageButton" ImageUrl="~/App_Themes/ICTTheme/immagini/edit.png">

<ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle>

</telerik:GridButtonColumn>

<telerik:GridButtonColumn CommandArgument="Delete" CommandName="Delete" ConfirmText="Are you sure that you want to delete this element?"

ConfirmTitle="Confirm Deletion" FilterControlAltText="Filter DeleteColumn column"

HeaderStyle-Width="20px" ItemStyle-Width="20px" FooterStyle-Width="20px" FilterControlWidth="20px"

Text="Delete" UniqueName="DeleteColumn" ButtonType="ImageButton" ImageUrl="~/App_Themes/ICTTheme/immagini/u39.png">

<ItemStyle HorizontalAlign="Center" CssClass="MyImageButton"></ItemStyle>

</telerik:GridButtonColumn>

</Columns>

</MasterTableView>

<FilterMenu EnableImageSprites="False">

</FilterMenu>

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">

</HeaderContextMenu>

</telerik:RadGrid>

<asp:ObjectDataSource ID="odsTask" runat="server" UpdateMethod="Update"

InsertMethod="Insert" DeleteMethod="Delete"

SelectMethod="FilteredView" TypeName="Aruba.ICT.Business.ExtendtedLogic.TaskExtendedLogic"

oninserted="odsTask_Inserted"

ondeleted="odsTask_Deleted" onupdated="odsTask_Updated">

<SelectParameters>

<asp:ControlParameter ControlID="DatePickerFrom" PropertyName="SelectedDate" Type="DateTime" Name="dateTimeFrom" />

<asp:ControlParameter ControlID="DatePickerTo" PropertyName="SelectedDate" Type="DateTime" Name="dateTimeTo" />

</SelectParameters>

</asp:ObjectDataSource>

<asp:ObjectDataSource ID="odsOperationsTask" runat="server"

DataObjectTypeName="Aruba.ICT.Business.ExtendedObject.OperationsTaskObject" SelectMethod="List"

TypeName="Aruba.ICT.Business.ExtendtedLogic.OperationsTaskExtendedLogic">

</asp:ObjectDataSource>

<asp:ObjectDataSource runat="server" SelectMethod="ListRecurrentType"

TypeName="Aruba.ICT.Business.ExtendtedLogic.TaskExtendedLogic" ID="odsCadency" />

<asp:ObjectDataSource ID="odsUsers" runat="server"

SelectMethod="ListAll"

TypeName="Aruba.ICT.Business.ExtendtedLogic.UtentiView">

<SelectParameters>

<asp:Parameter Type="Boolean" Name="ShowDeleted" DefaultValue="false" />

</SelectParameters>

</asp:ObjectDataSource>

2 Answers, 1 is accepted

answered on 08 Jul 2011, 08:33 AM

Hello Francesco,

I have examined your code and I cannot see an obvious reason for the described issue.
I tried to replicate it on the Filtering Template Columns demo with the City column, but to no avail.

If the problem persists, could you please elaborate on what you mean by "filter it doesn't work"?
Sending us a sample runnable project will be highly appreciated.

Greetings,
Mira
the Telerik team

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!