[JMH]

3 years, 1 month ago #33012

Hey Simplifier Team

Do i have any chance to use a Structure/Collection as Inputparameter instead of creating them all by hand.

 

Thx in advance

 

 

[Jennifer Häfner]

3 years, 1 month ago #33051

Up

1

Down

::

Hi,

yes, you can use collections in SQL connector calls by selecting ‘repeatable statement’ as the mode in the connector call. The SQL statement will then be executed for each element inside the collection.

Then, as the input parameter, select the datatype for the collection that you want to use.

For example, I have the datatype ‘fruit’ which contains objects with the fields ‘name’ and ‘colour’. The insert statement can look like this:

INSERT INTO Fruit (name, colour) VALUES (:name:, :colour:);

 

In Simplifier 7.0, configuring the collection data type looks like this:

 

If you use Simplifier 6.5, you need to add an input parameter called ‘parameterCollection’ and define the collection data type there (you can also find an example for that in this knowledge base article):

 

I hope this information is helpful!