How to create custom search functionality using a microflow

Hello Everyone. I am new to Mendix and want to develop custom search functionality. In which the user will enter the search string and press the button. I have created a helper entity that will store the search string. Can anyone please help to create a microflow which will return all results which matches with search string
1 answers

Add a “retrieve from database” microflow action to you microflow and add an xpath constraint where you use either the xpath constraint function “contains” or “starts-with” as so:

[contains(<Attribute>, $SearchHelper/SearchText] or [startsWith(<Attribute>, $SearchHelper/SearchText)]

You can have multiple contains and startsWith in one Xpath constraint, but please note that extensive use of contains might impose a performance punishment if you are searching over large datasets.