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>

Problem with filter

2 Answers, 1 is accepted