Hi Pankaj,
I read, you did all the filtering in microflow but it is having performance issues. And you want to do using XPATH. So, what you want to do in XPATH is still not clear to me.
Even if you want to retrieve in XPATH:
- you could possible do this with retrieve activity in microflow’s: https://docs.mendix.com/refguide/xpath-source
- Or you could choose to write a java action: https://docs.mendix.com/refguide/xpath. Also refer https://apidocs.mendix.com/7/runtime/com/mendix/core/Core.html#createXPathQuery-java.lang.String-
Did you try using a datagrid with xpath datasource and standard search filters?
If so, what was missing there?
You could also consider listview controls: https://appstore.home.mendix.com/link/app/105694/
Or grid search: https://appstore.home.mendix.com/link/app/49364/
I hope this helps.
What about a datagrid of accounts with xpath or database datasource, with standard serach filters for all attributes you are refering to. You can enable multiselect in those filters.
As soon as you click search, you will preview what accounts were selected. It will produce the selection in milliseconds without complex microflow filtering logic. You can fine tune the selection. Once satisfied with you selection, you let the user click a “call microflow” button called someting like “create surveys” which creates surveys for all accounts selected in the grid.
Would that work or am i still missing the point?
I get a better picture now. Thanks.
I see several options, there could be more options:
In you case, i would first try option 1, in many cases a lot of performance can be gained by just careful reconsideration.
And if that does not work, option 2. But that requires java knowledge.
I hope this helps.