Query to get Template list with fields mapped to it and default values.
Version : 14000
DB : PGSQL
OUTPUT :
select sd.name "Service Catalog Name",rt.templatename "Template name",fc.field_name "Fields",fc.default_value "Field Value" from requesttemplate_list rt
left join servicedefinition sd on sd.serviceid = rt.parent_service
left join form_customizer fc on fc.form_name = ('WorkOrder_' || rt.templatename)
left join servicedefinition sd on sd.serviceid = rt.parent_service
left join form_customizer fc on fc.form_name = ('WorkOrder_' || rt.templatename)