How do I add a column to a relationship tab dynamically.
I wish to federate an ItemType, the number of columns returned depends on the dataset and query combination and cannot be predicted prior to the query being run. Typically I would expect 30-40 columns, but could theoretically be up to 200.
My plan is to add a relationship type which is populated onGet, to bring back the required information using my Query. I would not to create a custom relationship view, as this will ensure compatibility with future upgrades.
What is the best way to proceed?
- Can I create columns dynamically to return the results?
Any help is appreciated.