Search Filter For Boolean value from Datagrid by search input
Question
Application Type
Reactive

I want to  search boolean values from data grid  by a input Search on screen 

there is a column of Status in grid which is bind by a structure attribute 'IsActive' 

and this attribute is Append in the list 

[IsActive = If(GetFormTemplatesByOrganizationId.List.Current.FormTemplate.IsActive,"Active","InActive")]

and JSON serialized it in string and show it on the DataGrid 'True as Active' and 'False as InActive' 

and I want to search by Active and InActive on the screen   

So, What filter Should I Write 

Solution

you can make a calculated Attribute in a aggregate then add a Condition for the New Attribute as below:

if(IsActive,"Active","InActive")

and can do Filter on this Attribute.

Hope this helps you !

Hello mohad ashraf,

from where you are fetching the data, is it the aggregate ?

yes,

From Aggregate


Solution

you can make a calculated Attribute in a aggregate then add a Condition for the New Attribute as below:

if(IsActive,"Active","InActive")

and can do Filter on this Attribute.

Hope this helps you !

Hi Mohd Ashra,

Here I am sharing sample oml file.

Hope this will help you.

All the  best

Thanks,

AJ

TestApp.oml

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.