[Jennifer Häfner Has successfully completed the online course Intermediate (200)Has successfully completed the online course Advanced (300)Has successfully completed the online course Basics (100)Has successfully completed the online course Advanced (310)Has successfully completed the online course Advanced (320)Has successfully completed the Intermediate CertificationHas successfully completed the Advanced Certification]

1 year ago #38466

Up

0

Down

::

Hi Samuel,

I recommend to merge the data in a Server-Side Business Object (SBO) function before loading it into the table. So, in the function, fetch the material data using the Connector call that you already use for the table. For each material, also fetch the stock data with the other Connector call. Add the stock data to the material object. Depending on your backend, this can be done in one Connector call, for example, by joining two tables in MySQL.

After having merged the data, the SBO function returns an array of material objects with an additional field (the stock data) and you can build your table just as you did before.

Does this help you?