Log in to AnswerLog in to Follow
2021-10-12 13-54-16
mohd Ashraf
29Views
4Comments
Solved
Search Filter For Boolean value from Datagrid by search input
Question
Reactive
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 

0
0
14 Jun
2020-10-07 11-01-58
Ekjot Singh
Solution

Replying to mohd Ashraf's comment on 15 Jun 2022 05:41:38

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 !

See solution in context
0
0
15 Jun

Hello mohad ashraf,

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

0
0
15 Jun

yes,

From Aggregate


0
0
15 Jun
2020-10-07 11-01-58
Ekjot Singh
Solution

Replying to mohd Ashraf's comment on 15 Jun 2022 05:41:38

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 !

0
0
15 Jun

Hi Mohd Ashra,

Here I am sharing sample oml file.

Hope this will help you.

All the  best

Thanks,

AJ

TestApp.oml

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