000029442 - Queries to retrieve information about all sub forms in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Jun 28, 2019
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000029442
Applies ToRSA Product Set: RSA Archer
RSA Version/Conditioon: 5.x, 6.x
Platform: Windows
IssueThis article explains how to create a query to retrieve information about all sub forms in RSA Archer.
ResolutionFor the subform fields used in various applications:

SELECT FD .field_id, FT. field_name, mt.module_name as ApplicationName, mt.module_id,   FT.field_desc , FD .Alias, ASO. aso_status_name,
FDS.search_default_field , FDS .required, FD. field_help_options
FROM tblIVFieldDef FD
JOIN tblLevel L ON FD .level_id = L .level_id
JOIN tblModule M ON M .module_id = L .module_id
JOIN tblModuleTranslation mt ON mt.module_id = M.module_id
JOIN tblFieldTranslation FT ON FT .field_id = FD .field_id
JOIN tblIVFieldDefSubform FDS ON FDS .field_id = FD .field_id
JOIN tblASOStatus ASO ON ASO .aso_status = FD .aso_status
WHERE FD .field_type_id = 24


For the actual subforms:

SELECT mt.module_name AS SubFormName , FT.field_name AS FieldsOnSubForm , mt.module_desc AS SubFormDesc,
M.Alias AS SubFormalias
FROM tblModule M
JOIN tblModuleTranslation mt ON mt.module_id = m.module_id
JOIN tblLevel L ON M .module_id = L .module_id
JOIN tblIVFieldDef FD ON FD .level_id = L .level_id
JOIN tblFieldTranslation FT ON FT .field_id = FD .field_id
WHERE M .module_type_id = 5

Attachments

    Outcomes