I have encountered an issue with lookup fields in my form. It is referencing a parent table with a lot of items.
In order to debug the problem, I reduce the parent table by deleting a lot of entities there. I could afterwards see all of those items (over 1.5mb of data) in the payload!!?? That's a lot to query for
So the form is prepared to render couple thousand items in the dropdown just from the beginning?! Now that's an overkill...
When I use dropdown, the control is requesting the items again anyway, wow....
This doesn't make sense....
How can I limit the lookup with any sort of filter before it renders? So the initial payload is reduced?
I can apply filter in fd.spBeforeRender, but it does not affect the size of "/renderlistformdata()" payload.
We have already subscribed the product, but this is a blocker now. I really need help with this one.
Thanks in advance.