Hello,
Any one can help me ? I'm new with APEX , working only on ora forms.
I following this blog https://blogs.oracle.com/apex/thats-a-classic-report-really
https://blogs.oracle.com/apex/thats-a-classic-report-really
I created a classic report with a sql and an attribute of media list template with search so I need to link this to page 4 passing the parameter of the PK empid to retrieve the information.
I created page 4 with process fetch row on pre-rendering after header if I can pass the value of the parameter then It will be work or retrieve records match with the parameter value LINK?
SELECT
fcms_employee_tel.fcms_emp_firstname
|| ' '
|| fcms_employee_tel.fcms_emp_secondname
|| ' '
|| fcms_employee_tel.fcms_emp_lastname AS list_title,
fcms_employee_tel.fcms_emp_position AS list_text,
'fa fa-user' AS icon_class,
'f?p=107:4:&APP_SESSION.::::P4_FCMS_EMP_ID:' ||:fcms_emp_id AS edit_link,
fcms.fcms_instn_main.f_compname list_badge,
'Employee ID' AS label_01,
fcms_employee_tel.fcms_emp_id AS value_01
FROM
fcms_employee_tel left outer
JOIN fcms.fcms_instn_main ON fcms_employee_tel.fcms_emp_comp_fk = fcms.fcms_instn_main.f_company
WHERE
( instr(lower(fcms_employee_tel.fcms_emp_firstname
|| fcms_employee_tel.fcms_emp_secondname
|| fcms_employee_tel.fcms_emp_lastname
|| fcms_employee_tel.fcms_emp_position),lower(:p2_search) ) > 0 )
OR (:p2_search IS NULL )
I have hard time to understand the link syntax on the apex developer guide. And this code on EDIT_LINK is not proper or working.