Skip to main content

RADplus 2023 Update 35

Product Requirements / Recommendations

RADplus required

Product Update Form Description

The 'SYSTEM.radplus_envelope_info' table is introduced to provide information about modeled envelopes.

Included Updates

None

Required Updates

None

Details

NEW1 CHANGED0 FIXED0
New (1)
Envelope definition data
The 'SYSTEM.radplus_envelope_info' table is introduced to provide the ability to query and display modeled "Envelope" definition data filed on the system
Value Added: Provides a client facing view to query envelope definition data
Topics
• SQL Data Access
 
Acceptance Tests

AV-87615 Summary | Details
Envelope definition data
Scenario 1: Validate data in the 'SYSTEM.radplus_envelope_info' SQL Table View
Specific Setup:
  1. Have one or more modeled "Envelopes" defined in form "Envelope Definition" in the "PM" namespace and in any child namespace's. For this test "CWS" and "MSO" have envelopes defined
  2. The user has permissions assigned to query table view 'SYSTEM.radplus_envelope_info' in their user definition
  3. Have a report created to display data in table view 'SYSTEM.radplus_envelope_info', in each namespace
Steps
  1. Open the report created for table view 'SYSTEM.radplus_envelope_info' in the "PM" namespace
  2. Click to generate the report
  3. Validate the report reflects all the expected envelopes, defined in that namespace
  4. Validate the following fields are populated for each envelope, based the field values selected in form "Envelope Definition"
  5. Build Application (Avatar PM)
  6. Build Environment
  7. Envelope ID
  8. Envelope Name
  9. Envelope (SQL) Schema
  10. Envelope Version
  11. Is Envelope Eligible for Export?
  12. Always Allow Export
  13. Open the report created for table view 'SYSTEM.radplus_envelope_info' in the "CWS" namespace
  14. Click to generate the report
  15. Validate the report reflects all the expected envelopes, defined in that namespace
  16. Validate the following fields are populated for each envelope, based the field values selected in form "Envelope Definition"
  17. Build Application (Avatar CWS)
  18. Build Environment
  19. Envelope ID
  20. Envelope Name
  21. Envelope (SQL) Schema
  22. Envelope Version
  23. Is Envelope Eligible for Export?
  24. Always Allow Export
  25. CDR (SQL) Schema
  26. Open the report created for table view 'SYSTEM.radplus_envelope_info' in the " MSO" namespace
  27. Click to generate the report
  28. Validate the report reflects all the expected envelopes, defined in that namespace
  29. Validate the following fields are populated for each envelope, based the field values selected in form "Envelope Definition"
  30. Build Application (Avatar MSO)
  31. Build Environment
  32. Envelope ID
  33. Envelope Name
  34. Envelope (SQL) Schema
  35. Envelope Version
  36. Is Envelope Eligible for Export?
  37. Always Allow Export
  38. CDR (SQL) Schema
Topics
• SQL Data Access
Table Changes

Table Column Change
SYSTEM.RADplus_envelope_info New

 

  • Was this article helpful?