Grade Scale edit: Task Approver: Invalid UpdateExpression Syntax Error when Approving Edited Grade Scale Data

[Adnan-shariff]

Describe the bug When attempting to update the Grade Scale by approving by clicking on accept. The error indicates an invalid UpdateExpression with syntax errors related to tokens such as "#scale", "#grade_scale_type", and "#low_range". and Id is being passed in approval section which seems also an issue

Scope of the bug This bug affects the functionality of updating Grade Scales in the application. Filter>Grade Scale type>Percentage>Edit

Steps to Reproduce

1. Open the Grade Scale section.
2. Filter the grade scales by selecting "percentage" from the "grade_scale_type" filter.
3. Select any data with "percentage" grade_scale_type.
4. Click on the "Edit" button to open the Grade Scale Edit form.
5. Make changes to the following fields: Country, Grade Scale type, Grade description, High range, Low range, out of, Scale.
6. Click on the "Save" button.
7. Go to "My Task Approver" section.
8. Click on "Grade Scale Edit" task.
9. Click on "Accept".
10. Select "New request raised".
11. Click on the "Accept" button.
12. Error message appears.

Expected Behavior The Grade Scale should be successfully updated without any syntax errors.

Actual Behavior An error message is displayed indicating syntax errors in the UpdateExpression.

Test Data to Reproduce

1. Test Data 1:

   • Old grade scale data:

     • low_range: 60
     • created_at: 1705075980088
     • column_range: lowrange, highrange
     • grade_scale_type: Percentage scale (PG-UCLAN)
     • high_range: 69.99
     • country: United Kingdom
     • out_of: 100
     • scale: 3.33
     • modified_at: 1705075980088

   • Edit grade scale data:

     • high_range: 66.99
     • scale: 5.33
     • id: 000000000G019W7C67391ZWW7Q
     • low_range: 62

2. Test Data 2:

   • Old grade scale data:

     • low_range: 50
     • created_at: 1624014310000
     • column_range: lowrange, highrange
     • grade_scale_type: Percentage Scale
     • high_range: 54.999
     • country: India
     • out_of: 100
     • scale: 2
     • modified_at: 1624014310000 .

   • Edit grade scale data:

     • high_range: 56.999
     • id: 000000000G0HNM68PS2KV8APXT

3. Test Data 3:

   • Old grade scale data:

     • low_range: 25
     • created_at: 1705075979492
     • column_range: lowrange, highrange
     • grade_scale_type: hs_Percentage Scale (75-100 A, 63-74 B+, 50-62 B, 25-49 C, 0-24 F)
     • high_range: 49.99
     • country: Ethiopia
     • out_of: 100
     • scale: 2
     • modified_at: 1705075979492

   • Edit grade scale data:

     • id: 000000000G00JXD4AV68AWQN15
     • low_range: 23

4. Test Data 4:

   • Old grade scale data:

     • low_range: 50
     • created_at: 1705075979751
     • column_range: lowrange, highrange
     • grade_scale_type: Percentage Scale (Shandong University)
     • high_range: 59.99
     • country: China
     • out_of: 100
     • scale: 1
     • modified_at: 1705075979751

   • Edit grade scale data:

     • id: 000000000G01HVXZ46YHKW7PSQ
     • low_range: 45

5. Test Data 5:

   • Old grade scale data:

     • low_range: 0.75
     • created_at: 1705075979868
     • column_range: lowrange, highrange
     • grade_scale_type: 4 GPA Scale (4 A , 3.75 A-, 3.5 B+,...)
     • high_range: 0.99
     • country: Jordan
     • scale: 1
     • modified_at: 1705075979868

   • Edit grade scale data:

     • country: Florida
     • grade_scale_type: 4 GPA Scale (4 A , 3.75 A-, 3.5 B+,..)
     • low_range: 1.75
     • out_of: 10
     • high_range: 1.99
     • id: 000000000G00BNVJBV6WZASJ7D

Screenshots

[Adnan-shariff]

working as intended we are able to do changes for percentage scales and other fields .