How to filter on enumeration field?

[Szabolcs]

Hi there,

I have a custom entity (Event) with Title, Date and State fields. The State field's type is Enumeration of "Active/Inactive".

I want to filter my data to show only the active events.

What is the syntax of it?

 I set the Items property of the Gallery object to Filter('Event', Title = "xyz") works well, but Filter('Event', State = Active) nor Filter('Event', State = "Active") do not work.

Thanks,

Szabolcs

[Perumal · Accepted solution]

Try Text() function to convert the State enumeration to string and compare as below.

Filter(Event, Text(State)="Active")

[Szabolcs]

Thanks Perumal,

It works fine.

Regards,

Szabolcs