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
Hello
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.Hello
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 E-mail address. We'll send you an e-mail with instructions to reset your password.
