How to filter with Enum DataType

[Peter]

Hi Guys,
I have problems when I filter with enum datatype.
my code sample is:

1) enum Days {Sat, Sun, Mon, Tue, Wed, Thu, Fri};

public class Person
{
  public Person()
  {}
  public Days DayAbsent
  {
get;
set;
  }
Public FirstName
.............
}

2) In RadGrid I have a column:
<telerik:GridBoundColumn SortExpression="DayAbsent" HeaderText="Day Absent" HeaderButtonType="TextButton"
                        DataField="DayAbsent" AllowFiltering="true">
                    </telerik:GridBoundColumn>
3) when I run filter of this column, I see error message:
[Telerik.Web.UI.ParseException] = {"Neither of the types 'String' and 'Days' converts to the other"}

Could you tell me how to fix this issue.
Thanks,
Peter.

[Tsvetoslav]

Hi aladin,

I am afraid filtering on an EnumType column is not a supported scenario.

Regards,
Tsvetoslav
the Telerik team

[Rod]

I would like to see this, I need this functionality as well to sort on the String representation of the enum.

[Tsvetoslav]

Hello Peter,

Unfortunately, our development team has deemed this feature not one of its priorities for the improvements in RadGrid based on very low, almost nonexistent, customer demand and the scale of the effort.

Greetings,
Tsvetoslav
the Telerik team

[Greg]

Since you say there's no demand, I thought I'd better pipe up and say:

I need this too.

Greg.

[Tsvetoslav]

Hello Greg,

Thanks for that  - we shall have it in mind.

Best wishes,
Tsvetoslav
the Telerik team

[Theunis Janse van Vuuren]

Make that three, add me to the list of demand.

We are running an application that has a Workflow tied to accounts, each account has a status and the description for the Status can get lengthy to type out for the users.

There are only a few set statuses that I can easily add as enums. Being able to Filter by those would be a huge win.

I am thinking of overriding the binding event for that Col client side and inserting DropDowns with the valid string value as the value and text field. Just not to sure where to start digging. Im not to phased about having events tied to the DropDown, only want to save the client the time in typing 'Account 1st Stage Verified' each time they want to see the accounts for that status.

So yes +1 me with an upsize...

Theunis

[Tsvetoslav]

Hi Chan,
hi Theunis, Greg and Rod,

Our development team researched the issue - unfortunately, RadGrid's design does not allow for the implementation of the feature under this support discussion. I am attaching a small sample that may provide some guidelines on how to work around this problem in some scenarios.

 

Greetings,
Tsvetoslav
the Telerik team

[Martin]

Has anything improved with Q1 2011 on filtering of Enums ?

Unfortunately it's quite common to use eNums in C# and to need to bind objects containing enum properties to the Telerik grid.

Whilst the values display ok in the grid the filters offer integer choices only rather than a selection list of the string equivalents. Also when editing values in cells it is the integer values that are requested (unfamiliar to the users of a system).

Martin

[Tsvetoslav]

Hi Martin,

My last post is still valid.

All the best,
Tsvetoslav
the Telerik team

[Ryan]

We need this functionality too. A quite common occurance.

[Shivanshu]

Hi , is this information still valid ??

[Tsvetoslav]

Hi Shivanshu,

Yes, it is.

Regards, Tsvetoslav
the Telerik team

[Shivanshu]

Thanks for update dear .. Any better work around for this ..Can you recommend any code spinet or blog or something which you think useful in this scenario...  

[Tsvetoslav]

Hi Chan,

The sample provided in my post from 2011 is a working one and provides a work-around to the filtering of enums. Once again, RadGrid does not support this scenario out-of-the-box.

Greetings, Tsvetoslav
the Telerik team

[Kyle Smith]

It is a bit disappointing that Enum filtering is not supported. I would recommend you re-evaluate the need for this type of support given the fact that the Entity Framework now supports Enums (I think as of 4.1?) AND since the RadGrid supports binding against the Entity Data Source.

I think you'll find that Enums are very popular when using the Entity Framework Code First approach. It would be SUPER useful if your development team could find a way to support this. It would make an already great control even greater!

Please add a +1 to this feature request for me!

In the meantime, I guess I'll have to convert to using OnNeedDataSource and convert my Entities to a DataTable. 

[Tsvetoslav]

Hi Kyle,

Do share your feedback at http://www.telerik.com/feedback.aspx .
 
Regards,
Tsvetoslav
Telerik

[Arun]

Add me to the list of demand. I need this functionality too. Did you have any update on "Enum filtering" Issue ?

[Vasil]

Hello Arun,

You can still work the workarownd provided by Tsvetoslav. Up to this date the Enum can not be filtered out of the box.

Regards,
Vasil
Telerik

[Lutz]

Well, it's over two years later, and I also need the ability to filter on enums. Very surprised that this is not a supported scenario... Any changes? I looked on the Feedback site, but did not see any item relating to this....

- Lutz

[Vasil]

Hi Lutz,

We do not planing to implement such filtering. We put some effort in research and it turns out that this is not possible to be built-in.

You will need to cast the enum to string in order to filter by it. Here is another forum that discuss possible workaround:
http://www.telerik.com/forums/radgrid-filtering-nullable-enums

Regards,
Vasil
Telerik