Issue while handling child entity tables data using "Write to Multiple Data Store Entities"

Hi,

I have a process model with the below scenario.

I have a main table where I need to store my parent db record and after generating the parent db record I am collecting the parent record id using script task. So far so good.

Now, I have a "Write to Multiple Data Store Entities" smart service using which I planning to store data (DB records) of the child tables and passing parent record id reference to the child tables. The way I have designed my db tables like using parent child reference keys (using primary, foreign key reference). I am good at this stage too.

Now, the issue was, I may or may not have child entity tables data. If there is no data in the child entities, still an empty row getting created in the child db table.

How can I handle the situation.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data