Skip to main content

How to Display Active URLs from XML Output in an RTF Template

 

Adding Hyperlink (URL) to XML Publisher

 When working with XML output, you might encounter fields that contain URL data. In many cases, it's not enough to simply display these URLs as plain text; you need to make them active links that users can click. Below will show you process of converting a URL field into an active hyperlink within an RTF (Rich Text Format) template, specifically for the field "CF_COURIER_URL".

We the column name is " CF_COURIER_URL" which contains the active url.



Create a form field in RTF for CF_COURIER_URL

Edit the form field and use the below command



 

<?if@inlines: CF_COURIER_URL!='N/A'?><fo:basic-link external-destination="{.//CF_COURIER_URL}"  color="blue" text-decoration="underline">External Url</fo:basic-link><?end if?>

 

Output:





Labels:

Comments

Post a Comment

Popular posts from this blog

API to Create & Update Price Adjustment and Order Lines

Important Tables: select header_id from oe_order_headers_all; select line_id from oe_order_lines_all; select list_header_id from qp_list_headers_all; select list_line_id from qp_list_lines; CREATE OR REPLACE PROCEDURE apps.xxapply_discount (p_header_id number) IS    v_api_version_number           number := 1;    v_return_status                varchar2 (2000);    v_msg_count                    number;    v_msg_data                     varchar2 (2000);    -- in variables --    v_header_rec                   oe_order_pub.header_rec_type;    v_line_tbl                     oe_order_pub.line_tbl_type;    v_action_request_tbl   ...
Post a Comment
Read more

Uninvoiced Receipts Query Oracle r12

Uninvoiced Receipts: SELECT   pha.segment1 po_number,          TO_CHAR (pha.creation_date, 'DD-MON-RRRR') po_date,          (SELECT   vendor_name             FROM   ap_suppliers ap            WHERE   ap.vendor_id = pha.vendor_id)             supplier_name,          pla.quantity,          pla.unit_price,          pla.quantity * pla.unit_price AS line_amount,          (SELECT   concatenated_segments             FROM   gl_code_combinations_kfv gcc            WHERE   gcc.code_combination_id = pda.code_combination_id)             charge_account,          rsh...
Post a Comment
Read more