Preload data in a search grid to avoid multiple select calls to the database
0
We're using the TextBoxSuggestion widget to autocomplete certain search criteria. as of now the widget uses either xpath or microflows to fetch data every time a character is pressed. Which means if i search for "What is my insurance?", mendix will execute 21 select statements. is there a way to pre-load the data based on the associations in the search grid? so that mendix doesnt do multiple selects?
asked
Osama Shalabi
1 answers
0
The AutoComplete widget has a microflow (cached) option that does what you're looking for.