Skip to main content

RADplus 2023 Update 63

Product Requirements / Recommendations

RADplus required

Product Update Form Description

The following changes are made: 1) 'SYSTEM.RADplus_dict_user_def_gaaso' table is added to allow dictionaries in the GA ASO indirect to be accessible via SQL. 2) An issue is resolved where the 'field_description' column in the 'SYSTEM.RADplus_dict_user_def_stateform' table is not populating.

Included Updates

None

Required Updates

None

Details

NEW1 CHANGED0 FIXED1
New (1)
GA ASO - Entity dictionaries
A new SQL table is introduced 'SYSTEM.RADplus_dict_user_def_gaaso', to enable users to query dictionary field values in the "GA ASO" entity database
Value Added: Provides users the ability to display dictionary codes and values in the "GA ASO" entity database
Topics
• SQL Data Access
 
Fixed (1)
State Form - Modeling table
An issue is resolved to ensure that when querying the 'SYSTEM.RADplus_dict_user_def_stateform' table, that the "field_description" field populates with data, as expected
Topics
• NX • State Form Tools
 
Acceptance Tests

AV-89749 Summary | Details
GA ASO - Entity dictionaries
Scenario 1: Validate the "SYSTEM.RADplus_dict_user_def_gaaso table
Specific Setup:
  • Have a modeled envelope [TestEnvelope] set to use "GA ASO" entity database
  • Have a modeled table[TestTable] created in [TestEnvelope] that contains the following dictionary fields. For this test the following will be used:
  • A 'Single-select" dictionary: Field number '1.01", with field description of "Dictionary 1".
  • Has the following dictionary code/values added:
  • Dictionary Code "1" with a dictionary value of "Single 1"
  • Dictionary Code "2" with a dictionary value of "Single 2'
  • A 'Multiple-select" dictionary: Field number '1.02", with a field description of "Dictionary 2"
  • Has the following dictionary code/values added:
  • Dictionary Code "5" with a dictionary value of "Mult 1"
  • Dictionary Code "6" with a dictionary value of "Mult 2"
  • Have a report or query created for table 'RADplus_dict_user_def_gaaso', to display dictionary codes, values and descriptions
Steps
  1. Generate the report or query created for table 'RADplus_dict_user_def_gaaso', to display field values
  2. Based on the set up, validate the report results display rows with the expected data populated in each column. For example, in this test following results would be expected:
  3. Field Number: "1.01" ; Field Description: "Dictionary 1" ;Dictionary Code: "1 ; Dictionary Value : "Single 1"
  4. Field Number: "1.01" ; Field Description: "Dictionary 1" ;Dictionary Code: "2" ; Dictionary Value : "Single 2"
  5. Field Number: "1.02" ; Field Description: "Dictionary 2" ;Dictionary Code: "5" ; Dictionary Value : "Mult 1"
  6. Field Number: "1.02" ; Field Description: "Dictionary 2" ;Dictionary Code: "6" ; Dictionary Value : "Mult 2"

Topics
• SQL Data Access
AV-89833 Summary | Details
State Form - Modeling table
Scenario 1: Validate table 'SYSTEM.RADplus_dict_user_def_stateform'
Specific Setup:
  • Have a modeled envelope [TestEnvelope] set to use "Stateform" entity database
  • Have a modeled table[TestTable] created in [TestEnvelope] that contains the following dictionary fields. For this test the following will be used:
  • A 'Single-select" dictionary: Field number '1.02", with field description of "Single Dictionary".
  • Has the following dictionary code/values added:
  • Dictionary Code "1" with a value of "One"
  • Dictionary Code "2" with a value of "Two"
  • Dictionary Code "3" with a value of "Three"
  • A 'Multiple-select" dictionary: Field number "1.03", with a field description of "Multiple Dictionary"
  • Has the following dictionary code/values added:
  • Dictionary Code "1" with a value of "One"
  • Dictionary Code "2" with a value of "Two"
  • Dictionary Code "3" with a value of "Three"
  • Have a report or query created for table 'SYSTEM.RADplus_dict_user_def_stateform', to dicitonary codes, values and descriptions
Steps
  1. Generate the report or query created for table 'SYSTEM.RADplus_dict_user_def_stateform' to display field values
  2. Based on the set up, validate the report results display rows with the expected data populated in each column. For example, in this test following results would be expected:
  3. Field Number: "1.02" ; Field Description: "Single Dictionary"; Dictionary Code: "1" ; Dictionary Value : "One"
  4. Field Number: "1.02" ; Field Description: "Single Dictionary"; Dictionary Code: "2" ; Dictionary Value : "Two"
  5. Field Number: "1.02" ; Field Description : "Single Dictionary"; Dictionary Code: "3"; Dictionary Value : "Three"
  6. Field Number: "1.03"; Field Description : "Multiple Dictionary" ;Dictionary Code: "1" ; Dictionary Value : "One"
  7. Field Number: "1.03"; Field Description : "Multiple Dictionary" ;Dictionary Code: "2" ; Dictionary Value : "Two
  8. Field Number: "1.03"; Field Description : "Multiple Dictionary" ;Dictionary Code: "3" ; Dictionary Value : "Three
Topics
• NX • State Form Tools
Table Changes

Table Column Change
SYSTEM.RADplus_dict_user_def_stateform field_description Changed compute code
SYSTEM.RADplus_dict_user_def_gaaso All Added

 

  • Was this article helpful?