Is it possible to combine two tables at interface level without using a view?Can we fetch the data with rules and join them thereafter?
Thanks is advance.
Discussion posts and replies are publicly visible
In your case, using displayvalue() function we can achieve this. If we need to show two cdts in same grid . you can use similar kind of approach mentioned below in values tab of GridColumn. If you want it to be in single virtual cdt , then we can directly form the cdt , if it is rightly ordered. If it is in different order using displayvalue we can form a proper single virtual CDT and use them efficiently in grid.
eg: apply(displayvalue( _, cdt2.commonValue, cdt2.otherColumn, {}),cdt1.commonValue)