Is it possible to filter on Enum property?

[matt-tolliday-iss]

I am using Enumerations for various properties, stored in the database as int fields.

I have configured a ValueMapper for Enum as follows, which works nicely on Create etc. which takes it's value from a configured Umbraco Dropdown DataType.

I am wondering if the scenario where I want to be able to add this as a FilterableProperty, using the dropdown DataType in Umbraco should be possible currently, or perhaps could be considered if not for Enum values.

It looks like it is using the string value rather than the integer value when running the DB query, and no records are returned as a result.

Have I missed something or is this taking the concept a bit far?

public class EnumValueMapper<TEnum> : KonstruktValueMapper 
        where TEnum : struct
    {
        public override object EditorToModel(object input)
        {
            if (input == null)
            {
                return input;
            }

            return Enum.Parse<TEnum>(input.GetUmbracoDropdownValue());
        }

        public override object ModelToEditor(object input)
        {
            if(input == null)
            {
                return input;
            }

            return $"[\"{input}\"]";
        }
    }

Example configuration as follows:

            .AddFilterableProperty(p => p.PaymentType, filterconfig => filterconfig
                      .SetLabel("Payment Type")
                      .SetDescription("The type of payment selected")
                      .AddOption(PaymentType.Card, PaymentType.Card.GetDisplayName())
                      .AddOption(PaymentType.Cheque, PaymentType.Cheque.GetDisplayName())
                      .AddOption(PaymentType.StandingOrder, PaymentType.StandingOrder.GetDisplayName())
                      .AddOption(PaymentType.DiretDebit, PaymentType.DiretDebit.GetDisplayName())
                  )

and with property Editor config as:

.AddField(p => p.PaymentType).MakeRequired().SetDataType(17277).SetValueMapper<EnumValueMapper<PaymentType>>().SetDescription("The payment type")

where the column model is defined as

[Column("PaymentType")]
public PaymentType PaymentType { get; set; }

and the enumeration is

public enum PaymentType
    {
        Card,
        Cheque,
        [Display(Name = "Direct Debit")]
        DiretDebit,
        [Display(Name = "Standing Order")]
        StandingOrder
    }

Configured as Dropdown DataType:

This displays in the "filter" of the collection as:

[mattbrailsford]

I think this may be because you are explicitly defining your options. Konstrukt can already automatically handle Enum property and convert the values into a dropdown (even handling DescriptionAttributes for friendly names) so you could try just not defining the options config and see if that works?

[matt-tolliday-iss]

Thanks @mattbrailsford that was indeed correct, removing the options configuration allowed the filtering to work as expected!

[mattbrailsford]

Perect! 👍