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

Article Id: 14892
Status: Published
Updated On: 14-02-2018 07:49
Legacy Id: TEC1548354
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