Skip to main content

RADplus 2024 Update 7

Product Requirements and Recommendations

RADplus required

Recommended Update Level

RADplus 2023 Update 96
RADplus 2024 Monthly Release 2024.00.01

Product Update Description

An issue is resolved where querying the 'service_type_value' property in the SYSTEM.RADplus_client_alerts table results in an UNDEFINED error.

Required Updates

None

Included Updates

None

Details

NEW0 CHANGED0 FIXED1
Fixed (1)
Client Alerts - SQL Table
An issue is resolved to ensure that "Client Alerts" table data can be displayed successfully, when querying the "SYSTEM.RADplus_client_alerts" table
Topics
• Client Alerts • Community Alert • SQL Data Access
 
Acceptance Tests

AV-94943 Summary | Details
Client Alerts - SQL Table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Client Alerts
Scenario 1: Validate querying data in the "SYSTEM.RADplus_client_alerts table"
Specific Setup:
  • Have two "Alert Types" configured in form "Alert Types"
  • [TypeA] is configured with prompt "Community Alert" set to "Yes"
  • [TypeB] is configured with prompt "Community Alert" set to "No"
  • Have access to form "Client Alerts" to add alerts for a desired client [TestClient]
  • Have a report or query to display field data in the "SYSTEM.RADplus_client_alerts" table
Steps
  1. At the Home View, select [TestClient]
  2. Open the "Client Alerts" form.
  3. From the "Type of Alert" select alert type [TypeA]
  4. From the Episode field select a desired episode [EpisodeA]
  5. Populate the "Start Date" and "End Date" fields
  6. Submit the form
  7. Validate the form files successfully
  8. Re-open the "Client Alerts" form.
  9. From the "Type of Alert" select alert type [TypeB]
  10. From the Episode field select a desired episode [EpisodeA]
  11. Populate the "Start Date" and "End Date" fields
  12. Submit the form
  13. Validate the form files successfully
  14. Open the report or query defined in the set up for the "SYSTEM.RADplus_client_alerts" table
  15. Click to preview data
  16. Validate there are two rows of data for [TestClient], one for each alert submitted
  17. Validate the data displayed in each row, is consistent with the data populated for each alert in steps 2 and 3
Topics
• Client Alerts • Community Alert • SQL Data Access