Description:
Deleting a draft post after a nondraft post has been made incorrectly reduces the interactive count and clears 'needs grading'.
Steps to Repeat:
- Log into Blackboard Learn as an administrator
- Create an Original Experience Course
- Go to Course Tools > Discussion Board
- Select 'Create Forum'
- Under the Forum Settings area, select grade: "Grade Discussion Forum" and set points; accept the default of 'show participants in needs grading after every "1" posts'
- The following example data condition is created:
BBLEARN_GIT=# SELECT gm.title, gm.score_provider_handle, cd.* FROM interactive_count_col_def cd, gradebook_main gm WHERE gradebook_main_pk1 = gm.pk1 AND gm.pk1 = 1639;
title | score_provider_handle | pk1 | gradebook_main_pk1 | trigger_count | activity_type | logical_and_ind
-----------------+-------------------------+-----+--------------------+---------------+---------------+-----------------
Gradable forum! | resource/x-bb-forumlink | 180 | 1639 | 1 | post | Y
(1 row)
- Enroll student users
- Switch to the test user and access the Discussion Forum
- Select 'create thread', and type some values in the form. Select 'Save Draft', not 'submit'
Observe that the thread seemingly disappears (you can only access it via the 'thread view' view and 'list view' is default). This is a 'sub-bug'.
- Now create an entirely new thread and submit it, the following data condition is created:
BBLEARN_GIT=# SELECT * FROM interactive_count WHERE col_def_pk1 = 180;
pk1 | col_def_pk1 | attempt_pk1 | group_attempt_pk1 | count | date_modified
-----+-------------+-------------+-------------------+-------+-------------------------
111 | 180 | 24976 | | 1 | 2022-06-09 13:00:24.002
(1 row)
- The item is now showing the "needs grading" medallion in the GUI (do not grade it)
- Go to "tree view" as the student and observe that both the draft and the actual posts exist.
- Select the draft post and delete it
Expected Behavior:
The item remains "needs grading."
The count in interactive_count is not reduced
Observed Behavior:
The item now shows "--" in the grade center.
The database shows:
BBLEARN_GIT=# SELECT * FROM interactive_count WHERE col_def_pk1 = 180;
pk1 | col_def_pk1 | attempt_pk1 | group_attempt_pk1 | count | date_modified
-----+-------------+-------------+-------------------+-------+-------------------------
111 | 180 | 24976 | | 0 | 2022-06-09 13:01:47.392
~~~~~~~~ HERE ~^
