Thursday, June 4, 2015

Query to Find Attached Template Name from Template Code


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';


Reactions:

0 comments:

Post a Comment