Hello everyone!
I have an interactive report that show me some records about files updated to the DB.
When i have only one record it works well, display only the record that exists and i can download it, but when i have two or more records i get the Not Found error when trying to download the file and it display the same record multiple times like below:
my query is like this:
SELECT R.ID,
RA.ID RA\_ID,
TD.STRDESCRICAO,
CASE WHEN EXISTS (SELECT RA.ID
FROM REQUERIMENTOANEXO RA
WHERE FKEREQUERIMENTO = :P300400\_REQ\_ID AND RA.TIPODOCUMENTO = TD.ID)
THEN 'Sim'
ELSE 'Não'
END AS ANEXADO,
CASE WHEN ATD.BLNOBRIGATORIO = 1 THEN 'Sim' WHEN ATD.BLNOBRIGATORIO = 0 THEN 'Não' END as Obrigatório,
dbms\_lob.getlength(RA.ARQUIVO) as ARQUIVO
FROM REQUERIMENTO R
INNER JOIN ASSUNTOTIPODOCUMENTO ATD ON ATD.FKEASSUNTO = R.FKEASSUNTO
INNER JOIN TIPODOCUMENTO TD ON TD.ID = ATD.FKETIPODOCUMENTO
LEFT JOIN REQUERIMENTOANEXO RA ON R.ID = RA.FKEREQUERIMENTO
WHERE R.ID = :P300400\_REQ\_ID;
when i changed the query to this:
SELECT distinct R.ID,
(SELECT RA.ID
FROM REQUERIMENTOANEXO RA
WHERE FKEREQUERIMENTO = :P300400\_REQ\_ID AND RA.TIPODOCUMENTO = TD.ID) ra\_id,
TD.STRDESCRICAO,
CASE WHEN EXISTS (SELECT RA.ID
FROM REQUERIMENTOANEXO RA
WHERE FKEREQUERIMENTO = :P300400\_REQ\_ID AND RA.TIPODOCUMENTO = TD.ID)
THEN 'Sim'
ELSE 'Não'
END AS ANEXADO,
CASE WHEN ATD.BLNOBRIGATORIO = 1 THEN 'Sim' WHEN ATD.BLNOBRIGATORIO = 0 THEN 'Não' END as Obrigatório,
(SELECT dbms\_lob.getlength(RA.ARQUIVO) FROM REQUERIMENTOANEXO RA
WHERE FKEREQUERIMENTO = :P300400\_REQ\_ID AND RA.TIPODOCUMENTO = TD.ID) as ARQUIVO
FROM REQUERIMENTO R
INNER JOIN ASSUNTOTIPODOCUMENTO ATD ON ATD.FKEASSUNTO = R.FKEASSUNTO
INNER JOIN TIPODOCUMENTO TD ON TD.ID = ATD.FKETIPODOCUMENTO
LEFT JOIN REQUERIMENTOANEXO RA ON R.ID = RA.FKEREQUERIMENTO
WHERE R.ID = :P300400\_REQ\_ID;
it show me the records in the correct way, but i still can't download the files
what can i do to solve this?
Using APEX 5.1.4 and Oracle 11g XE
Thanks in advance,
Alibune.