Main Region

Multiple Fileupload - automatic filling fields
3 answers | 326 views
CH
Christian86
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
Matt Nolan
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
Christian86
Oct 13, 2014 06:51 +00:00

Do you mean an database trigger?

Christian

0 comments
KR
Kristof
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.