CODEWITHSUNDEEP
oracle-apex
Tom
Tom

Reputation: 167

How to add file browser in interactive grid row - Oracle Apex

Is it possible to convert a field from an interactive grid in a file browser?. I really need to upload the files according to the rows that a table has configured

select descripcion, alias
  from documento_tipo dt
 where requerido = 'S'
union all
select dt.descripcion, dt.alias
  from documento_tipo_ramo dtr
  join documento_tipo dt
    on dtr.documento_tipo = dt.id
  join cia_riesgo ramo
    on dtr.ramo = ramo.id
  join riesgo r
    on ramo.riesgo = r.id
 where r.id = :P15_ID

If you can't, is there any other solution?, thank you.

Upvotes: 1

Views: 2273

Answers (1)

Akil_Ramesh
Akil_Ramesh

Reputation: 431

There is no option to add file browse in an IG. Please follow the below steps as a work around.

  1. Create a Modal Dialog page (example: Page 2)

  2. Create a Hidden item in the page. This is to hold your Primary Key value. (example: P2_ID).

  3. Create a link column in your Interactive Grid. On click, the link must redirect to the modal page (page: 2). Pass the value of the primary key from the IG to the P2_ID Item. (Refer below screenshot).

enter image description here

  1. Create a File browse Item in Page 2.

Then follow the steps in the below link to save your uploaded file.

File browse Item uploading to BLOB column

Upvotes: 2

Related Questions