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 @lilpancho1 ,
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:
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:
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.