Skip to main content

RADplus 2022 Update 116

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

RADplus required

Product Update Form Description

The following modifications are made to the State Reporting Tools: 1) The 'State Form Query Logging' form is modified to store the last run query for each State Form Definition rather than the last run query run overall. 2) The 'State Form Compile Parameters' form is added to allow parameters to be passed in to State Form Definitions at compile time. 3) The 'State Form Definition Versioning' form is added to allow different versions of a single State Form Definition to be maintained within a single copy of the definition. 4) The ability to overwrite an existing State Form Definition on import is added.

Included Updates

7, 15, 24, 24.1, 50, 112

Required Updates

None

Details
NEW3 CHANGED0 FIXED0
New (3)
State Form Query Logging - form
The 'State Form Query Logging' form is updated to store the last query that was run for each "State Form Definition"
Value Added: Allows users to see the last query that was run for any "State Form Definition" file
Topics
• NX • State Form Tools
 
'State Form Parameters Definition' - form
The "State Form Parameters Definition" form is added, which will be used to define parameters that can be passed to a "State Form Definition" at the time the file is compiled.
Value Added: Gives the user flexibility to pass user specified parameters when compiling a state form definition file
Topics
• NX • State Forms
 
'State Form Definition Versioning' form
The 'State Form Definition Versioning' form is added to allow different versions of a single 'State Form Definition' to be maintained. In addition, the ability to "Overwrite" an existing state form file during file import is added.
Value Added: Gives user the ability keep multiple versions of a single state form definition and overwrite an existing file on import
Topics
• NX • State Forms
 
Acceptance Tests
AV-80741 Summary | Details
State Form Query Logging - form
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • State Form File Generation
  • State Form Query Logging
Scenario 1: 'State Form Query Logging' form - Functionality and validations
Specific Setup:
  • Have a system with two state form file definitions created in form "State Form Definition" [SFileA] and [SFileB]
  • [SFileA] is a definition that contains one record [Rec]
  • [SFileB] is a definition that contains two records [Rec] and [Rec2]
  • Have a report to display data in the "RADplus_sf_audit_query" table, sorted by the "ID" field and displaying the fields "ID", "Query" and "Rec"
Steps
  1. Open form "State Form File Generation"
  2. Select definition [SFileA] in the "State Form" field. (Make a note of the file "ID" number located next to the state form file name)
  3. Select "Compile" in the "File Generation Options" field
  4. Populate the "File Description" field
  5. Click [Process]
  6. At the "Compile Complete" dialog, click [OK]
  7. Open form "State Form Query Logging"
  8. Select definition [SFileA] in the "State Form" field
  9. Validate the "Record" filed is automatically populated with the record name [Rec]. (Make a note of the record name)
  10. Validate "Query" field is populated with the expected SQL query based on the table and selection criteria being executed in the record, [Make a note of the query displayed]
  11. Close the form
  12. Run the report created to query table "RADplus_sf_audit_query" table
  13. In the "ID" column, locate the row that contains a value starting with the definition "ID" for [SFileA], noted in step 1a
  14. Validate the "Record" field value matches the value noted in step 2a
  15. Validate the "Query" field value matches the value noted in step 2a
  16. Close the report
  17. Open form "State Form File Generation"
  18. Select definition [SFileB] in the "State Form" field. (Make a note of the file "ID" number, located next to the state form file name)
  19. Select "Compile" in the "File Generation Options" field
  20. Populate the "File Description" field
  21. Click [Process]
  22. At the "Compile Complete" dialog, click [OK]
  23. Open form "State Form Query Logging"
  24. Select definition [SFileB] in the "State Form" field
  25. Click the "Record" field
  26. Validate there are two records for selection, as expected. [Rec] and [Rec2]
  27. Select [Rec]
  28. Validate the "Record" field is automatically populated with the record name [Rec]. (Make a note of the record name)
  29. Validate "Query" field is populated with the expected SQL query based on the table and selection criteria being executed in the record, [Make a note of the query displayed]
  30. Navigate back to the "Record" field
  31. Select [Rec2]
  32. Validate the "Record" field is automatically populated with the record name [Rec]. (Make a note of the record name)
  33. Validate "Query" field is populated with the expected SQL query based on the table and selection criteria being executed in the record, [Make a note of the query displayed]
  34. Run the report created to query table "RADplus_sf_audit_query" table
  35. In the "ID" column, locate the row(s) that contains a value starting with the definition "ID" for [SFileB], noted in step 4a
  36. Validate a row is found for record name [Rec]
  37. Validate the "Query" field value for record [Rec] matches the value noted in step 5a
  38. Validate a row is also found for record name [Rec]
  39. Validate the "Query" field value for record [Rec2] matches the value noted in step 5a
  40. Close the report
Topics
• NX • State Form Tools
AV-80774 Summary | Details
'State Form Parameters Definition' - form
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • State Form Definition
  • State Form File Generation
  • State Form File Generation - File Dump Report
  • State Form Parameter Definition
Scenario 1: 'State Form Parameters Definition" form - Functionality and validations
Specific Setup:
  • In form "Update Client Data", have one or more clients on the system that have any "Date", "Single-Select" field and "Multi-Select" field populated. For this test the following fields will be used:
  • "Martial Status", single-select field
  • "Date of Birth", date field
  • "Other Languages", multi-select field
  • Have a state form definition file [StateFile] set up in form "State Form Definition", that extracts "PATID", "Name", "Marital Status", "Date of Birth" and "Other Languages" from the "SYSTEM.patient_current_demographics" table
  • In form "State Form Definition", edit file [StateFile]
  • Navigate to the "Define Record Table" section of the definition and
  • Select the row defined containing the "SYSTEM.patient_current_demographics" table
  • Navigate to the "Additional SQL Conditions" column and populate the field with the following SQL parameter "p.marital_status_code={?Param1}"
  • Submit the form
Steps
  1. Open form "State Form Parameter Definition"
  2. Select [StateFile] in the "State Form Definition" field
  3. Select "Add New" in the "Select Parameter" field
  4. Set the "Parameter Description" field to a desired name for the single-select field. For this example, "Marital Status"
  5. Validate the "Parameter Number" field contains "1"
  6. Validate the "Parameter Reference" field contains "{?Param1}"
  7. Select "Single Select Dictionary" in the "Parameter Type" field
  8. Select "Yes" in the "Required" field
  9. In the "Entity Database" field, select "Client"
  10. Search and select "(10) Marital Status" from the "Dictionary" field
  11. Select "Active" in the "Status" field
  12. Click the [File] button
  13. Validate the form submits successfully
  14. Open form "State Form File Generation" and select [StateFile] in the "State Form" field
  15. Click the "Compile" radio button in the "File Generation Options" field
  16. Set the "File Description" field to the desired name. For example, "Married Clients File"
  17. Click the Process button
  18. The user is prompted with a "Select Values - Dialog"
  19. Validate the "Martial Status" dictionary selection list is displayed
  20. Select the desired marital status and click [OK]
  21. Click [OK] at the "Compile Complete" message
  22. In the "File Generation Options" field, select the "Dump File" radio button
  23. Click [Process]
  24. Validate the "Data Dump File - Report" contains only clients with a "Martial Status" field equal to the value selected in the previous step
  25. Close the report
  26. Open form "State Form Definition", edit the state form file [StateFile]
  27. Navigate to the "Define Record Table" section of the definition and
  28. Select the row defined containing the "SYSTEM.patient_current_demographics" table
  29. Navigate to the "Additional SQL Conditions" column and replace the previous SQL parameter with one for the "Date" field. For this test enter "p.other_lang_code={?Param2}"
  30. Open form "State Form Parameter Definition"
  31. Select [StateFile] in the "State Form Definition" field
  32. Select "Marital Status" in the "Select Parameter" field, entered in step 1
  33. Click [Delete] to removed it
  34. Click the "Select Parameter" field and select "Add New"
  35. Validate the "Parameter Number" field contains "1"
  36. Validate the "Parameter Reference" field contains "{?Param1}"
  37. Set the "Parameter Description" field to a desired name for the multi-select field. For this example, "Other Languages"
  38. Select "Multi-Select Dictionary" in the "Parameter Type" field
  39. Select "Yes" in the "Required" field
  40. In the "Entity Database" field, select "Client"
  41. Search and select the multi-select field, for this test,"(149) Primary Language" is selected
  42. Select "Active" in the "Status" field
  43. Click the [File] button
  44. Validate the form submits successfully
  45. Open form "State Form File Generation" and select [StateFile] in the "State Form" field
  46. Click the "Compile" radio button in the "File Generation Options" field
  47. Set the "File Description" field to the desired name. For example, "Other Languages File"
  48. Click the [Process] button
  49. The user is prompted with a "Select Values - Dialog"
  50. Validate the "Other Languages" dictionary selection list is displayed
  51. Select the desired values and click the [OK] button
  52. Click [OK] at the "Compile Complete" message
  53. In the "File Generation Options" field, select the "Dump File" radio button
  54. Click [Process]
  55. Validate the "Data Dump File - Report" contains only clients that have the "Other Languages" field populated with the value(s) selected in the previous step
  56. Close the report
  57. Open form "State Form Definition", edit the state form file [StateFile]
  58. Navigate to the "Define Record Table" section of the definition and
  59. Select the row defined containing the "SYSTEM.patient_current_demographics" table
  60. Navigate to the "Additional SQL Conditions" column and replace the previous SQL parameter with one for the "Date" field. For this test enter "p.date_of_birth={?Param1}"
  61. Submit the form
  62. Open form "State Form Parameter Definition"
  63. Select [StateFile] in the "State Form Definition" field
  64. Select "Other Languages" in the "Select Parameter" field, entered in step 1
  65. Click [Delete] to removed it
  66. Click the "Select Parameter" field and select "Add New"
  67. Validate the "Parameter Number" field contains "1"
  68. Validate the "Parameter Reference" field contains "{?Param1}"
  69. Set the "Parameter Description" field to a desired name for the multi-select field. For this example, "Date of Birth"
  70. Select "Date" in the "Parameter Type" field
  71. Select "Yes" in the "Required" field
  72. Select "Active" in the "Status" field
  73. Click the [File] button
  74. Validate the form submits successfully
  75. Open form "State Form File Generation" and select [StateFile] in the "State Form" field
  76. Click the "Compile" radio button in the "File Generation Options" field
  77. Set the "File Description" field to the desired name. For example, "Date of Birth File"
  78. Click the [Process] button
  79. The user is prompted with a "Select Values - Dialog"
  80. Validate the "Date of Birth" input field is displayed
  81. Enter the desired date and click [OK]
  82. Click [OK] at the "Compile Complete" message
  83. In the "File Generation Options" field, select the "Dump File" radio button
  84. Click [Process]
  85. Validate the "Data Dump File - Report" contains only clients that contain a date of birth equal to value populated in the previous step
  86. Close the report
Topics
• NX • State Forms
AV-82415 Summary | Details
'State Form Definition Versioning' form
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • State Form Definition
  • Enter a description of any changes made- Dialog
  • State Form Definition Versioning
Scenario 1: State Form Definition - Import/Export
Specific Setup:
  • Have a state form definition file created in form "State Form Definition". [SFDefFile]
Steps
  1. Open form "State Form Definition"
  2. Click section "State Form Definition File Import/Export"
  3. Select [SFDefFile] from the "Select State Form For Export" field
  4. Click [Export State Form]
  5. Click [Save] to save the file [SFileExp] to a folder
  6. Close the form
  7. Open form "State Form Definition"
  8. Select [SFDefFile] for edit
  9. Navigate to any field on the form and note its current value. For example the "File Type" field
  10. Enter or select a new value in the field
  11. Submit the form
  12. Open form "State Form Definition"
  13. Select [SFDefFile] for edit
  14. Validate the change made to the field in step 2 is present as expected
  15. Close the form
  16. Open form "State Form Definition"
  17. Click section "State Form Definition File Import/Export"
  18. Click [Select File for Import]
  19. Navigate to the location of the export file [SFileExp]
  20. Select the file
  21. Click [Open]
  22. Click [Process Import]
  23. Validate message "Import Complete" is displayed
  24. Close the form
  25. Open form "State Form Definition"
  26. Select [SFDefFile] for edit
  27. Validate the change made to the field in step 2, has returned to its original value
  28. Close the form
Scenario 2: "State Form Definition Versioning" form - Functionality and validations
Specific Setup:
  • A state form file definition file exists, created in form "State Form Definition" [StateFormFile]
Steps
  1. Open form "State Form Definition Versioning"
  2. Select [StateFormFile] from the "State Form Definition" field
  3. Click "Create New Version" in the "Action" field
  4. Validate the "Version Number" field is set to "1"
  5. Click "Create New Subversion"
  6. Validate a message stating a subversion cannot be created until the initial version is created is displayed
  7. Click [OK]
  8. Click "Create New Version"
  9. Populate the "Version Description" field
  10. Submit the form
  11. Return to form "State Form Definition Versioning"
  12. Select [StateFormFile] from the "State Form Definition" field
  13. Click "Create New Subversion"
  14. Validate a message is displayed stating that the current version must be finalized before a subversion can be created
  15. Click [OK]
  16. Click "Finalize Version
  17. Validate a message is displayed stating that once this form is submitted, the definition cannot be modified until a new version is created.
  18. Click [OK]
  19. Click [Submit]
  20. Return to form "State Form Definition Versioning"
  21. Select [StateFormFile] from the "State Form Definition" field
  22. Click "Create New Subversion" in the "Action" field
  23. Validate the "Version Number" field contains "1.01"
  24. Populate the "Version Description" text field
  25. Submit the form
  26. Open form "State Form Definition"
  27. Select [StateFormFile] from the "State Form Definition" field
  28. Validate the "Version Number" field contains "1.01"
  29. Change any field value on the form. For this example the "File Type" was changed from "Delimited" to "XML"
  30. Click the [File Form] button
  31. In the "Enter a description of any changes made" dialog, enter a description of the change
  32. Click the OK button
  33. Close the form
  34. Open form "State Form Definition Versioning"
  35. Select [StateFormFile] from the "State Form Definition" field
  36. Validate the "Version Number" field has a value of "1.01"
  37. Validate the "Change Log" text box contains: "Version 1.01", the description of the change, the time/date of the change and name of the user who filed the change
  38. Click "Restore Version" in the "Action" field
  39. Select "1" from the "Select Version" field
  40. Submit the form
  41. Open form "State Form Definition"
  42. Select [StateFormFile] from the "State Form Definition" field
  43. Validate the "Version Number" field has a value of "1"
  44. Validate the field value change made in step 4, has been reverted back to its original value. (For this test, the "File Type" field value has been reverted back to its original value of "Delimited")
  45. Close the form
  46. Open form "State Form Definition Versioning"
  47. Select [StateFormFile] from the State Form Definition field
  48. Click "Restore Version" in the "Action" field
  49. Select "1.01" from the "Select Version" field
  50. Submit the form
  51. Open form "State Form Definition"
  52. Select [StateFormFile] from the "State Form Definition" field
  53. Validate a warning is displayed "Definition is currently final, editing is not permitted unless a new version is created in the 'State Form Definition Versioning' form.
  54. Validate the [File Form] and the [Delete Form] buttons are disabled
  55. Validate the field value change made in step 4 has returned. (For this test, the "File Type" field value has returned to changed value of "XML" made in step 4)
  56. Close the form
  57. Open form "State Form Definition Versioning"
  58. Select [StateFormFile] from the State Form Definition field
  59. Validate the "Version Number" field is populated with "1"
  60. Click "Delete Version" in the "Action" field
  61. Submit the form
  62. Click "Yes" to return to the form
  63. Select [StateFormFile] from the State Form Definition field
  64. Validate the "Version Number" field is populated with "1.01"
  65. Click "Restore Version" in the "Action" field
  66. Validate message "No additional versions found for selected definition" is displayed
  67. Click [OK]
  68. Close the form
Topics
• NX • State Forms