000029434 - Query to retrieve information about calculated fields from the database

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000029434
Applies ToRSA Product Set : Archer

RSA Version/Condition : 5.x

Note: This query will work only on versions prior to 5.5.2.

Platform : Windows
IssueQuery to retrieve information about calculated fields from the database
Resolution
Select M.module_name as 'Application Name', L.level_name as 'Level Name',
FD.field_name as 'Field Name', FT.field_type_name as 'Field Type',
c.calc_order as 'Calculation order', c.formula as 'Formula', c.enforce_calc as 'Always Calculate',
c.is_handle_error as 'Display novalue/specific error',
CEV.numeric_value as 'Specific error value_Numeric', CEV.select_value_id as 'Specific error value_list',
Cev.string_value as 'Specific error value_text', CEV.date_value as 'Specific error value_Date'
from tblIVFieldDef FD
join tblLevel L on L.level_id=FD.level_id
join tblModule M on M.module_id=L.module_id
join tblIVFieldType FT on FT.field_type_id=FD.field_type_id
join tblCalc C on C.field_id=FD.field_id
full outer join tblCalcErrorValue CEV on FD.field_id=CEV.field_id order by module_name,level_name,calc_order

Attachments

    Outcomes