Can Filter control handle expressions what compare two fields?

4 posts, 0 answers
  1. Svyatoslav Isayev
    Svyatoslav Isayev avatar
    4 posts
    Member since:
    Oct 2004

    Posted 07 Jan Link to this post

    The common scenario for filter expression is that Column is compared to a value, ex. TransactionId=12345. But can you create an expression that would allow user to specify comparison of 2 fields instead, e.g. TransactionId=CurrentTransactionId?
  2. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 12 Jan Link to this post

    Hi Svyatoslav,

    I would suggest you to revise the help topic below that elaborates on this matter:
    http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/filtering/how-to/operate-with-the-filterexpression-manually

    Regards,
    Maria Ilieva
    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
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Svyatoslav Isayev
    Svyatoslav Isayev avatar
    4 posts
    Member since:
    Oct 2004

    Posted 12 Jan in reply to Maria Ilieva Link to this post

    Dear Maria,

     

    The link that you suggested does not address the situation I'm talking about. I'll try to explain in more detail...

     

    Let's say I have an entity represented by a table TestTable:

    -----------------------------------------------------------------------------------------

    |  TransactionId  |  AgreementId  |  CurrentTransactionId  |  Value  |

    -----------------------------------------------------------------------------------------

    |              15431  |            12        |                         15433   |        22 |

    |              15432  |            12        |                         15432   |        22 |

    |              15433  |            12        |                         15431   |        22 |

     

    I want to allow user to build a filter that would correspond to the WHERE clause of the following SQL expression :

     

    SELECT *

    FROM TestTable

    WHERE TestTable.TransactionId=TestTable.CurrentTransactionId

     

    Is this something that can be done with Telerik's Filter control?

  5. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 18 Jan Link to this post

    Hello,

    Unfortunately the required functionality can not be achieved with the RadFilter control.
    The suggested help topic demonstrates the filter expressions supported by Telerik syntax and you can apply the required SQL syntax per your need.

    Regards,
    Maria Ilieva
    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