Skip to main content

RADplus 2023 Update 85

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

RADplus required

Recommended Update Level

RADplus 2016 Update 130
RADplus 2023 Monthly Release 2023.03.00

Product Update Description

An issue where the "AddClientToTeam" and "RemoveClientFromTeam" web services did not add or remove a consumer from an individual team assignment is resolved. Following RADplus2023 Update #026, additional internal utilities are updated to resolve additional issues of SQL table permissions between two users whose User IDs differed only by the placement of periods.

Required Updates

None

Included Updates

2, 4, 6, 12, 14, 22, 25, 26, 29, 33, 35, 49, 55, 56, 58, 59, 64, 71, 75, 80

Details
NEW0 CHANGED0 FIXED2
Fixed (2)
User SQL table permissions
Additional internal utilities are updated to ensure that respective SQL table permissions are assigned, in the case where two users have the same User ID's that differ only by the placement of periods within their User ID's.
Topics
• SQL Data Access
 
Team Definition - Web Service
An issue is resolved to ensure that the "Team Definition" web service requests, "AddClientToTeam" and "RemoveClientFromTeam" can be executed successfully to add and remove clients from a team. KB0074330 v0.01
Topics
• Team Definition
 
Acceptance Tests
AV-89547 Summary | Details
User SQL table permissions
Scenario 1: Validate a user's SQL "ODBC" Table permissions
Specific Setup:
  • Have two users exist on the system that have the same "User ID" that differ only by where the period within their user ID is placed. These users are 'not' assigned to a user role.
  • For this test: "U.serA" and "User.A"
  • "U.serA" has access to the "SYSTEM.patient_current_demographics" table but does 'not' have access to the "SYSTEM.Admission_data" and "SYSTEM.Appt_data" table.
  • "User.A" also has access to "SYSTEM.patient_current_demographics" table and 'does' have access to the "SYSTEM.Admission_data" and "SYSTEM.Appt_data" tables.
  • Two other users exist on the system that have the same "User ID", that differ only by where the period within their user ID is placed. These users 'are' assigned to a user role.
  • For this test: "R.user" and Ruse.r"
  • "R.user" has access to the "SYSTEM.patient_current_demographics" table but 'does not' have access to the "SYSTEM.Admission_data" and "SYSTEM.Appt_data" table.
  • "Ruse.r" also has access to "SYSTEM.patient_current_demographics" table and 'does' have access to the "SYSTEM.Admission_data" and "SYSTEM.Appt_data" tables.
  • Each user has a "User Data Sources" name configured using MS-Windows "ODBC Data Source Administrator" application, to connect to the testing data base.
  • Have access to "Crystal Reports" or other database program to make an ODBC connection and view SQL Table permissions for the users defined in this set up.
Steps
  1. Open the database program, for this example "Crystal Reports" is used.
  2. Click "File" on the menu and then "New" to create a new report.
  3. At the "Data" dialog, click "Create New Connection".
  4. Double-click "ODBC".
  5. From the "Data Source Selection" dialog, locate the data source name created for user ID "U.serA" and double-click to select it.
  6. Populate the "User ID" field and "Password" with the credentials for "U.serA".
  7. Click "Finish".
  8. At the table tree list:
  9. Click the "SYSTEM" schema folder and then click "Tables".
  10. Validate the "SYSTEM.patient_current_demographics' table is present in the list.
  11. Validate the "SYSTEM.Admission_data" and "SYSTEM.Appt_data" tables are "not" present, as expected.
  12. Click 'Cancel".
  13. Click "File" on the menu and then "New" to create a new report.
  14. At the "Data" dialog, click "Create New Connection".
  15. Double-click "ODBC".
  16. From the "Data Source Selection" dialog, locate the data source name created for user ID "User.A".
  17. Populate the "User ID" field and "Password" with the credentials for "User.A".
  18. Click "Finish".
  19. At the table tree list:
  20. Click the "SYSTEM" schema folder and then click "Tables".
  21. Validate the "SYSTEM.patient_current_demographics' table is present in the list.
  22. Validate the "SYSTEM.Admission_data" and "SYSTEM.Appt_data" tables "are" present, as expected.
  23. Open the database program, for this example "Crystal Reports" is used.
  24. Click "File" on the menu and then "New" to create a new report.
  25. At the "Data" dialog, click "Create New Connection".
  26. Double-click "ODBC".
  27. From the "Data Source Selection" dialog, locate the data source name created for user ID "R.user" and double-click to select it.
  28. Populate the "User ID" field and "Password" with the credentials for "R.user".
  29. Click "Finish".
  30. At the table tree list:
  31. Click the "SYSTEM" schema folder and then click "Tables".
  32. Validate the "SYSTEM.patient_current_demographics' table is present in the list.
  33. Validate the "SYSTEM.Admission_data" and "SYSTEM.Appt_data" tables are "not" present, as expected.
  34. Click 'Cancel".
  35. Click "File" on the menu and then "New" to create a new report.
  36. At the "Data" dialog, click "Create New Connection".
  37. Double-click "ODBC".
  38. From the "Data Source Selection" dialog, locate the data source name created for user ID "Ruse.r".
  39. Populate the "User ID" field and "Password" with the credentials for "Ruse.r".
  40. Click "Finish".
  41. At the table tree list:
  42. Click the "SYSTEM" schema folder and then click "Tables".
  43. Validate the "SYSTEM.patient_current_demographics" table is present in the list.
  44. Validate the "SYSTEM.Admission_data" and "SYSTEM.Appt_data" tables "are" present, as expected.
Topics
• SQL Data Access
AV-90425 Summary | Details
Team Definition - Web Service
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Team Definition
Scenario 1: "Team Definition" Web Service - Add/Remove Client from Team
Specific Setup:
  • Have a team [TestTeam] defined in form "Team Definition".
  • Have a client [TestClient] that's admitted in an episode [TestEpisode], that needs to be added to that team.
  • Have the "WEBSVC.TeamDefinition" set up and configured to connect to the testing database in program "SoapUI" or other web service program.
Steps
  1. Open "SoapUI".
  2. Navigate to the "WEBSVC.TeamDefinition" web service.
  3. Click "AddClientToTeam" item and double click on "Request1" to open a new request.
  4. Populate the following required fields with the values needed to execute the web service on the testing system.
  5. With "Client ID" set to [TestClient], "EpisodeNumber" set to [TestEpisode] and "TeamID" set to the team ID number for [TestTeam].
  6. SystemCode
  7. UserName
  8. Password
  9. ClientID
  10. EpisodeNumber
  11. TeamID
  12. Click to process the request.
  13. Validate the request results indicate "Client has been successfully added to the team".
  14. In Avatar:
  15. Navigate to the "Team Definition" form.
  16. Select [TestTeam] for edit.
  17. Navigate to the "Individual Client Assignment" section.
  18. Validate a row is present for [TestClient] in the "Individual Client Assignment" grid, as expected.
  19. Validate the "Client ID" field is populated with [TestClient].
  20. Validate the "Episode(s)" field is populate with [TestEpisode].
  21. Close the form.
  22. Return to "SoapUI".
  23. Navigate to the "WEBSVC.TeamDefinition" web service.
  24. Click "RemoveClientFromTeam" item and double click on "Request1" to open a new request.
  25. Populate the following required fields with the values needed to execute the web service on the testing system.
  26. With "Client ID" set to [TestClient], "EpisodeNumber" set to [TestEpisode] and "TeamID" set to the team ID number for [TestTeam].
  27. SystemCode
  28. UserName
  29. Password
  30. ClientID
  31. EpisodeNumber
  32. TeamID
  33. Click to process the request.
  34. Validate the request results indicate "Client has been successfully removed from the team".
  35. In Avatar:
  36. Navigate to the "Team Definition" form.
  37. Select [TestTeam] for edit.
  38. Navigate to the "Individual Client Assignment" section.
  39. Validate the row for [TestClient] has been removed from the "Individual Client Assignment" grid, as expected.
  40. Close the form.
Topics
• Team Definition