Main Region

Multiple Fileupload - automatic filling fields
3 answers | 326 views

CH
Oct 13, 2014 05:32 +00:00

Good Morning

I am using the Multiple File Upload Plugin and it works fine. Now my question: I want to fill two or more filds dynamic in the Database Table. So I used the "Foreign Key Column" option. There I can only fill one field. What if I want to fill more than one field?

Thank you, Christian

4 comments

MN
Matt Nolan Oct 13, 2014 06:52 +00:00 

Yes a before insert database trigger. e.g.

CREATE OR REPLACE TRIGGER myTrig BEFORE INSERT OR UPDATE ON myTable FOR EACH ROW BEGIN ...

MN
Matt Nolan May 29, 2015 07:29 +00:00 

This will be coming in v2.1.0, so for now yes you have to use the trigger.

KR
Kristof Nov 26, 2015 11:07 +00:00 

Is this possible in version v2.1.0 (or later) ? The Foreign Key Column and Foreign Key Page Item don't seem to allow multiple values.

MN
Matt Nolan Nov 26, 2015 11:13 +00:00 

Apologies this feature has been bumped to the next release v2.2.0, for v2.1.1 and below you will have to use the trigger method described above.

MN
Oct 13, 2014 06:49 +00:00

There are some open enhancements to the multiple file upload plugin which we will be adding in a future release, this being one of them.

For now you will have to use a Before insert trigger and reference an item from session state.

e.g.

IF INSERTING THEN
   :NEW.my_column := nvl(v('P1_ITEM_NAME'), 'Default Value');
END IF;
0 comments

CH
Oct 13, 2014 06:51 +00:00

Do you mean an database trigger?

Christian

0 comments

KR
May 29, 2015 07:11 +00:00

will it be possible to specify multiple columns in the "Foreign Key Column" in (one of) the next version(s) ? Or do we still have to use the workaround with the trigger ?

0 comments

You must log in or sign up to post questions and answers.