When Test cases are moved simultaneously from the Orphans folder, the counters of the folders may become out of sync, and Test cases may be found in several folders.
Since the Test Plan Board only accepts the existence of one Test case per folder, this needs to be fixed.
Please execute the steps below to fix the counters and assure that only one Test case solely belongs to a folder.
Step-by-step guide
Please run this query on your instance database (please note that you may need to format the query to your Database syntax):
SELECT * FROM (SELECT TEST_ID,COUNT(*) AS COUNT from AO_8B1069_LEAF WHERE ENTITY_ID = 'Your_Test_Plan_issue_id' GROUP BY TEST_ID) AS COUNTS WHERE COUNTS.COUNT > 1
Make sure to replace Your_Test_Plan_issue_id in the query with the correct value.
You can find it by navigating to your Test Plan and hovering the mouse pointer over the Edit button. On the bottom of your browser, the preview URL will display the issue id value.
Take the TEST_ID column values and navigate to the JIRA Issue Search, and on Advanced run the following query:
id in (TEST_ID_1, TEST_ID_2, ...)
And create a Saved Filter Duplicated Tests with it.
- Navigate to the Test Plan Board Folder where the problem occurred, use the Filter, and on the Saved Filter option input the previously created Duplicated Tests, and Apply.
- Change the view to the Folder view.
- Now, all the tests that appear are repeated at least one time; please take note of the issue key of each Test if you have tests inside the Orphans folder.
- Select all the Tests, right-click on the selected tests and choose the option Move to Orphans.
- Now, you have all the tests inside the Orphans folder, select all the tests from the Orphans folder or the tests that you take note and move to the original folder.