Skip to Content (Press Enter)
2021-04-09 11-42-43
assif_tiger
 
MVP
82Views
3Comments
Solved
How to Filter Local Storage Entity Data from SearchInput
Question

I have designed a List & the data is in Local Storage Entity,

I want to filter List based on SearchInput onChange Event.

I was planning to make an action & use SQL to do so, But as of my Data is in Local Storage I am unable to do so.

-Assif


RefImg.png
0
0
27 Jul 2018
Copy Link
2021-04-09 11-42-43
assif_tiger
 
MVP
Solution

Thanks Kilian,

It resolved by Aggregates - FIlter : 

SyntaxEditor Code Snippet

EmployeeRecords.emp_name like "%" + TextVar + "%" 


TextVar : Variable for SearchInput

Event : OnChange - Action [ Refresh Data]


See solution in context
0
0
27 Jul 2018
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Assif,

Regardless of whether you create a Mobile App or a Web App, you should try to limit the use of SQL and use Aggregates where possible. As you are creating a Mobile App, Aggregates are the only solution available as you know, so your filter has to be created via a Filter in an Aggregate. So what exactly do you want to filter that you think isn't possible using an Aggregate Filter?

0
0
27 Jul 2018
Copy Link
2021-04-09 11-42-43
assif_tiger
 
MVP
Solution

Thanks Kilian,

It resolved by Aggregates - FIlter : 

SyntaxEditor Code Snippet

EmployeeRecords.emp_name like "%" + TextVar + "%" 


TextVar : Variable for SearchInput

Event : OnChange - Action [ Refresh Data]


0
0
27 Jul 2018
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Yes, that's indeed the way to solve that, using "like" in an Aggregate Filter. Great you managed to solve it!

0
0
27 Jul 2018
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.