i want to make a test management tool, right now using google sheets.

[shashank_pandey]

In google sheets there are many problems like duplicate testcase and the management is also hectic. Could you suggest some ways and requirements to do this. Like we can use db or something like that. if there is a tool which exists please me mention that also. I am thinking of making a framework also.

[Tomasz Korusiewicz_SolDevelo · Accepted solution]

Hi @shashank_pandey 

If you are looking for an additional tool for Jira that will suit your test management needs and don't mind getting a solution from the Atlassian Marketplace, then I suggest our app, developed in-house by SolDevelo, called 'QAlity Plus – Test Management for Jira'.

QAlity Plus streamlines the process of creating and managing test cases. You can write and execute test cases directly from the issue view, providing quick and convenient access to your tests.

Each test step can include associated test data, an expected result, and relevant attachments.

The Test Case Repository enables you to organize, filter, and create test cases, storing them in custom-named folders for better structure and accessibility.

Finally, the test cases can be both exported and imported into your Jira instance, meaning that with some additional preparation work, you can import the data from your existing spreadsheet files into the app, making the data transfer from and into QAlity Plus easier!

If you are interested in this solution, we kindly invite you to check it out!

Best regards,
Tomasz

[shashank_pandey]

Thanks @Tomasz Korusiewicz_SolDevelo , will try this and inform you if i face any issue

[Brita Moorus · Accepted solution]

Hi, @shashank_pandey! 👋

If you're facing issues with Google Sheets for test management, you can use Atlassian tools to build a better system without plugins:

• Use Jira to manage test cases as issues (create a "Test Case" issue type, create necessary custom fields for detailed tracking).

• Track execution using custom workflows, statuses, and labels (f.e, Passed, Failed, Skipped).

• Use Confluence to document test plans and link them to Jira test cases.

• Create dashboards and filters in Jira to avoid duplicates and track coverage.

• Store and version test scripts or automation code in Bitbucket.

• Link Bitbucket commits to Jira issues for traceability (tests linked to features or bugs).

• No plugins needed - just customize Jira projects, fields, and boards.

Hope this helps! ✨

[shashank_pandey]

Thanks @Brita Moorus , i will check it out

[Weronika Hałdaś_Deviniti_ · Accepted solution]

Hi @shashank_pandey 

When it comes to Jira plugins that can support your testing process, you can try the Deviniti app - Requirements & Test Management for Jira

This application allows you to:

• gather requirements
• create test plans, test cases, executions, and defects
• generate reports
• integration with automated testing tools
• manage the entire testing process in one place

Kind Regards,
Weronika

[shashank_pandey]

@Weronika Hałdaś_Deviniti_ Thanks for the information