Skip to main content

Hello, I am looking for a table in the db containing a pdf file with payslips. I need to know how to match it to the company and employee.

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! :)


Reply