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
Solved! Go to Solution.
Try Text() function to convert the State enumeration to string and compare as below.
Filter(Event, Text(State)="Active")
Try Text() function to convert the State enumeration to string and compare as below.
Filter(Event, Text(State)="Active")
Thanks Perumal,
It works fine.
Regards,
Szabolcs
User | Count |
---|---|
179 | |
120 | |
87 | |
44 | |
41 |
User | Count |
---|---|
245 | |
156 | |
128 | |
77 | |
73 |