Telerik Radgrid enablelinqexpressions when set to true still the filter expression returned is in SQL format

6 posts, 0 answers
  1. Anup
    Anup avatar
    11 posts
    Member since:
    Mar 2011

    Posted 13 Jan Link to this post

    I have a telerik radgrid used on my page.I have set the enablelinqexpressions property to true. What i read in blog was when we set this property we get the filter expression in the linq format like this - "(iif(Message == null, \"\", Message).ToString().ToUpper().Contains(\"f2e\".ToUpper()))" but i am still getting the filter expression in the SQL format.

     Am i missing any thing ?

     

    Please find below few of my radgrid code snippet:

    <telerik:RadGrid ID="gridResults" runat="server" AllowFilteringByColumn="True"
            AllowPaging="True" AllowCustomPaging="True" AllowSorting="True" AutoGenerateColumns="False"
            CellSpacing="0" EnableAJAX="True" GridLines="None" PageSize="20" Skin="Windows7"
            OnNeedDataSource="gridResults_NeedDataSource" OnItemCommand="gridResults_ItemCommand" Visible="False">
            <GroupingSettings CaseSensitive="False" />
            <ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True" />
            <ExportSettings OpenInNewWindow="true" ExportOnlyData="true" HideStructureColumns="true" />
            <MasterTableView CommandItemDisplay="Top" AllowMultiColumnSorting="False">
                <CommandItemSettings ShowAddNewRecordButton="false" ShowExportToCsvButton="true" ShowExportToExcelButton="true" ShowRefreshButton="false" />
                <SortExpressions>
                    <telerik:GridSortExpression FieldName="Timestamp" SortOrder="Descending" />
                </SortExpressions>

  2. Anup
    Anup avatar
    11 posts
    Member since:
    Mar 2011

    Posted 13 Jan in reply to Anup Link to this post

    Just missed to mentioned that the property enablelinqexpressions  is set to true which i missed in the above code snippet
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Eyup
    Admin
    Eyup avatar
    3005 posts

    Posted 18 Jan Link to this post

    Hello Anup,

    The EnableLinqExpressions property is enabled by default. I've created a sample RadGrid web site to demonstrate that the filter expression is built as expected. Please run the attached application and let me know about the result.

    Regards,
    Eyup
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  5. Anup
    Anup avatar
    11 posts
    Member since:
    Mar 2011

    Posted 18 Jan in reply to Eyup Link to this post

    Hi Eyup,

    Thanks for the reply.

    I went through your sample code. But i problem here is I have a List collection which i am bind to the grid in the needdatasource event.

    and the filterexpression i am getting is in SQL format. so when i try to filter my collection with grid filter expression it gives me an error.

  6. Anup
    Anup avatar
    11 posts
    Member since:
    Mar 2011

    Posted 18 Jan Link to this post

    Hi Eyup,

    I am expecting the filter expression is linq format. Why i am getting the same in SQL format.

  7. Eyup
    Admin
    Eyup avatar
    3005 posts

    Posted 21 Jan Link to this post

    Hello Anup,

    I suggest that you modify the provided sample to demonstrate the described problem and open a formal support ticket to send it back to us.

    Regards,
    Eyup
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017