How do I find the Javascript for a form in the database?

Products

• CA Service Catalog
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

In current releases, it is generally recommended to place the custom JavaScript for a form in the definition of the form itself, rather than in the filestore. Once this has been done, however, how can I retrieve this from the database directly, rather than through the User Interface?

Environment

Release: CASVCT99000-12.9-Service Catalog
Component:

Resolution

I have a custom form called "testforma" defined, with some JavaScript present. The following query will retrieve it:

Select attr_long_value from usm_form_component_attrib_ext e
  where e.form_comp_attr_id in
  (select c.form_comp_attr_id from usm_form_component_attributes c, usm_form_entities d
  where c.form_comp_id = d.form_entity_id
  and d.form_entity_name = 'testforma')

 

Additional Information

The following TEC doc will help you find the form name and/or ID, if you only have the request ID: TEC1642177