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

Question

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.

Akil_Ramesh · Accepted Answer · 2021-09-20 06:32:04Z

2

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

Create a Modal Dialog page (example: Page 2)
Create a Hidden item in the page. This is to hold your Primary Key value. (example: P2_ID).
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).

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

answered Sep 20, 2021 at 6:32

Akil_Ramesh

4414 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tom Over a year ago

Good evening, I try to try the recommended option however I have the following problem: One of my items on the main page (P15_SOLICITUD_ID) is loaded through javascript that executes a function in the database $s('P15_SOLICITUD_ID',answer.idSequence); but when I add it in the link builder (name: p4_solicitud_id, value: &P15_SOLICITUD_ID.) and run the modal it does not recognize it since the modal item comes out soft

Tom Over a year ago

I have asked a new question here link, maybe you can help me, thank you

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related