How to Filter values that equals to null

2 posts, 0 answers
  1. He
    He avatar
    3 posts
    Member since:
    Oct 2010

    Posted 12 Jun 2011 Link to this post

    Hi, Data Filter has many filter condtion such as " Is Equal To", "Contains", "Not Contained In" and so on.
    Does it support "Has Value" to filter those value is not null?
    If not, can I extend it myself to do it? How?
  2. Rossen Hristov
    Rossen Hristov avatar
    2478 posts

    Posted 14 Jun 2011 Link to this post

    Hi He,

    If you enter an empty string in the filter editor it should translate it to null. Then if you select the IsNotEqualTo operator from the filter operator combo this will produce the expression:

    Member IsNotEqualTo null

    which I guess is what you want. It should return all items which have a value different from null.

    You can controls the available filter operators through the FilterOperatorsLoading event. 

    You can create a custom filter editor if you need to by following this help topic and looking at this online example.

    I hope this helps.

    the Telerik team
    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 Public Issue Tracking system and vote to affect the priority of the items
Back to Top