pdf wtih payslip in db

Hi @PaulinaPi,

Please try the below query:

SELECT a.lu_name, a.doc_no, key_ref, file_data
FROM doc_reference_object_tab a, edm_file_storage_tab b
WHERE a.doc_class = b.doc_class
AND a.doc_no = b.doc_no
AND a.doc_rev = b.doc_rev
AND a.doc_sheet = b.doc_sheet;

Best Regards,

Charitha

I tried it and thank you for this solution. I feel that we are close to the resolve my problem :) but in these tables i don’t have payslips pdf 

Best Regards

Paulina

Hi @PaulinaPi,

If you use PL/SQL Developer to run the query, you can click on the 3 dots in the FILE_DATA column and view the PDF from there.

Best Regards,

Charitha

I would like to show you all  LU_name witch I have like a result this query - I don’t know witch one can be a payslip.

That why I wrote that is good way but it not resolve my problem I think all of this query looks like that is what I need but I can’t find payslip.

Regards 

PPI

I think that I found resolve :

select a.*,b.*
  from archive_parameter_tab a, pdf_archive_tab b
 where a.result_key = b.result_key
   and
      
       b.layout_name = 'EmpPayment.rdl'

Yes this is a different approach than what I initially suggested. Glad it worked! :)