Hi Ahmad,
If i underderstand correctly, you have a boolean for each possible status value ?
So your filter would look something like this
ShowConcept and SomeEntity.Status = Entities.Status.Concept or ShowActive and SomeEntity.Status = Entities.Status.Active or ShowCancelled and SomeEntity.Status = Entities.Status.Cancelled or not (ShowConcept or ShowActive or ShowCancelled) //if none selected, show all
Dorine
Thank you, By adding the last line to my filter (Not....) this fix my issue and now I got the correct result
Checkboxes and booleans work like all other column datatypes, but they differ on 1 special use case:
You actually need 3 options per checkbox, but you only have 2 (true or false / on or off).
I would create a static entity where you can map the 2 boolean-values (true and false) and add another: (ALL). And then make your aggregate select those.
i am assuming you already know how to filter your aggregate in a form with filter.
First create one attribue in name as "Status" and data type is "Boolen". Then create a check box in Required screen. For result showing screen aggregate add one filter like (That status attribute = true)