RADplus 2024 Update 72

Last updated
Save as PDF

Product Requirements and Recommendations

RADplus required

Recommended Update Level

RADplus 2022 Update 12
RADplus 2024 Monthly Release 2024.01.02

Product Update Description

The error 'One or more SQL queries failed to compile', which may occur in 'Form Definition' when an SQL query contains several similar parameters, is resolved. An issue where the 'sign_capture_date' and 'sign_capture_time' columns may not be populated for signature fields on modeled forms is resolved.

Required Updates

None

Included Updates

Details

NEW0 CHANGED0 FIXED2

Fixed (2)

AV-98725 Details \| User Acceptance Tests Form Definition - SQL Query Ensure the ability to submit 'Form Definition' when an SQL query contains several similar parameters. KB0077040 v0.01	Topics • Forms • Modeling

AV-98999 Details \| User Acceptance Tests Modeled Forms - Signature fields Ensure the 'sign_capture_date' and 'sign_capture_time' columns are populated in the table for modeled forms containing signatures KB0077035 v0.01	Topics • Forms • Modeling • Signatures

Acceptance Tests

AV-98725 Summary | Details

Form Definition - SQL Query

Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:

Table Definition (PM)

Scenario 1: Modeling - Form Definition - Validate forms containing an SQL query

Specific Setup:

A modeled form (Form A) is defined with an SQL query field (Field A).
A client is enrolled in an existing episode (Client A).

Steps

Select "Client A" and access "Form A".
Populate all required and desired fields.
Validate "Field A" is displayed and contains the proper results based on the SQL query.
Select the desired value in "Field A".
Submit the form.
Select "Client A" and access "Form A".
Select the record filed in the previous steps and click [Edit].
Validate all previously filed data is displayed.
Close the form.

Topics

• Forms • Modeling

AV-98999 Summary | Details

Modeled Forms - Signature fields

Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:

Table Definition (PM)

Scenario 1: Modeled Form - Validate signature fields

Specific Setup:

Signatures must be enabled in 'System Security Defaults'.
A modeled form (Form A) is defined with the following:
A binary table (Table A) for storage
A signature field
Supports Automatic Backup set to "Yes"
Two clients are enrolled in existing episodes (Client A & Client B).

Steps

Select "Client A" and access "Form A".
Populate all required and desired fields.
Sign in the 'Signature' field.
Submit the form.
Select "Client B" and access "Form A".
Populate all required and desired fields.
Sign in the 'Signature' field.
Click [Backup] and close the form.
Select "Client B" and access "Form A".
Click [Yes] to restore from backup.
Validate the previously filed data is displayed.
Click [Submit].
Access Crystal Reports or other SQL Reporting tool.
Create a report using "Table A".
Validate the rows for "Client A" and "Client B" are displayed.
Validate both rows contain data in the 'sign_capture_date' and 'sign_capture_time' fields.
Close the report.

Topics

• Forms • Modeling • Signatures