Tuesday, 16 June 2015

To identify the Template name using template code in xml report

SELECT template_code, file_name FROM xdo_templates_b a, xdo_lobs b WHERE b.lob_code = a.template_code AND b.xdo_file_type='RTF' AND a.template_code = 'XXXBITEMPLATE';

No comments:

Post a Comment