Inserting multiple records in the database using writeback functionality through Pre-Update query

[Prateek Rawat]

Hi All,

I want to insert new rows in the database table named "user_lookup"with two columns user_id and region.

user_id is set through an input field whereas value for Region is set via amultiselect list box filter.

To update the record I have created an IL for the above table user_lookup and loaded it on demand.

In on demand settings Iam setting user_id and region values through parameters.

I have written below Insert query in IL's pre-update:

insert into user_lookup (region,user_id)

values ( region,

userid)

This function works if there is only 1 value selected for region in the multiselect list box as shown below:

 

 

 

user_id

region

 

 

1

US

 

 

 

How can Itweak this so that when I selected multiple values in the region list box(Multi-Select), multiple records are inserted at a time for a particular User Id as shown in the table below:

 

 

 

user_id

region

 

 

1

US

 

 

1

Africa

 

 

1

 

Europe