Loading huge data in reference set selector.

2
Dear All, We have a use case where around one million rows exists on an entity which needs to be loaded via reference selector. I am using microflow as source for the reference selector. Currently, i am running into heap exception due to the large amount of data. I also have a feeling that it is incorrect to have data of that size in a single call. I was thinking some alternatives such as async way of loading with search and sort capabilities for the dropdown. Not sure we have something of that sort out of the box. Can you please suggest some idea to handle this situation. Thank you. Regards, Chengaiah
asked
2 answers
2

First of all, you should not do this in a dropdown, you should use a select page. It has the pagination and search options you are looking for.
Second: Is there any way to get the data via xpath instead of microflow? If you could define your selectable objects via xpath, the system would not need to retrieve everything at once. If xpath is not working because of the logic, you may want to consider using some helper entity that you use to cache the selectable objects list and use xpath on your reference selector.

answered
1

Hi there,

Large drop down selectors are not easy for the users, besides the performance draw back. you might want to rethink the design.

For large sets, lay loading, with search and select, have a look at https://appstore.home.mendix.com/link/app/2695/ 

Or explore some of the other widgets in the AppStore

Cheers, Andries

answered