How can you report the defect using excel sheet?
Answer Posted / mukesh sharma
Bug List in excel sheet contains mentioned fields:
Bug ID : Unique no./name for future reference.
Description : Summary about bug/defect/error.
Raised in Build/ Release/ Version/ Sprint : The version no. of current build, in this build test engineers detected the bug.
Feature : The name of module / function / feature, in that area test engineers found the bug.
Test Case Name : The name of failed test case, in that case execution test engineer found this bug.
Status : Life cycle of the bug.
New : A new bug detected by a tester
Open : A bug that has been reviewed and verified as a true bug
Rejected : A bug that has been found not to be a bug
Assigned : A bug that has been verified by development and is now assigned to developers for fixing
Fixed : A bug that has been fixed and is ready for retesting
ReTest : A bug that has been fixed by developers, which is once again tested to be closed
ReOpen : A bug that has failed testing during ReTest
Closed : A bug that has successfully passed retesting
Deferred : A bug that has been mutually agreed to move to the next release or later releases.
Duplicate : If the bug is repeated twice or the two bugs mention the same concept of the bug, then the recent/latest bug status is changed to “duplicate“.
Not A Bug : If there is no change in the functionality of the application. Work as expected.
Severity : The seriousness of bug in terms of functionality.
High : Not able to continue testing with out resolving this bug (show stopper)
Medium : Able to continue remaining testing, but mandatory resolve.
Low : Able to continue remaining testing and may / may not to resolve.
Priority : Importance of bug to resolve in terms of customer (High, Medium, Low)
Detected By : Name of test engineer.
Assigned To : The name of responsible person at development side to receive this bug report.
Open Date : Date of bug found.
Closed Date : Date of bug fixed.
Verified in Build/ Release/ Version/ Sprint : The version no. of current build, in this build test engineers tested and verified the bug.
Testers Comments : Comments related to Bug Status, Severity, Priority, Suggestion to fix etc. Comments by testers.
Developers Comments : Comments by developers
Attachment : Screenshot or video Link.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to test the case with 5 combination and inputs
why testcases are written and what is the importance?
how to create automation frame work ?
What knowledge I must have as a 3 yrs. manual tester??
What if an organization is growing so fast that fixed testing processes are impossible? What to do in such situations?
Hi, I was asked following question during a interview. Please answer it: Password field is there,we can accepts every character except underscore and semicolon. It can accept min 6 characters and maximum 12 characters. Prepare boundary value and equivalence class test cases.
What will be your approach if a particular script in Load Test fails?
How to test the below code and write test case? Prove that this code is wrong? int add(int a ,int b) {return a+b; }
Please let me know how to test labels in web application manually and how the testcases would be. Please provide me a sample testcase
What is the difference between manual testing and automation testing?
what is the relation between all tabs in quality center & explain the testing process in quality center with tabs?
Can anyone tell me about banking project? abt the transactions? the flow?
What is the role of the test group vis-?is documentation, tech support, and so forth?
Have you ever completely tested any part of a product? How?
1)can u tell me, what is the roles and responsibles for database tester in DB testing from requirement stage to UAT stage....2) what are the i/p documents he wants and who wil give the i/p docs. to DB tester.and tell me what exactly db test case means what?