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
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.