Hello Community,
I have a service instance containing multiple tables. I need to combine data from 4 to 5 of the tables (in same service instance), it possible to create a Composite/Advanced SmartObject and join all the tables I need or is there a limit to how many sources/tables you can use OOTB? I have tried to do so unsuccessfully thus far. Any help or advice would be appreciated.
Best answer by lkimberly
View originalHello
Is this an SQL server? You could use a Store Procedure of View in SQL to pull the data from multiple tables then create a SmartObject off that or create a SmartObject for each table and then create the associations between these SmartObjects. Please have a look at the following link for more information:
Regards,
Kimberly
K2 will not accept any liability for any issues arising from actions taken in respect of information provided by any forum member.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
