Process - Reporting Rework Faults - Revision history

Anw: Minor correction

2025-07-28T09:37:37Z

Minor correction

← Older revision		Revision as of 11:37, 28 July 2025
Line 5:		Line 5:

	== Configuration ==		== Configuration ==
	~~For reference, see Queries/Shared Queries/CTY/CTY Logs Entered by TW.~~


	Create a query with the following columns:		Create a query with the following columns:

	* Title		* Title
	* Assigned To		* Assigned To

Anw: Updated

2025-07-28T09:34:00Z

Updated

@@ Line 32: / Line 32: @@
 ** Custom Customer Contains - Enter a part of the customer
-If possible, use a shared query or create a shared query .
+If possible, use a shared query or create a shared query.
 Create a DevOps Bug List spreadsheet from template.[[File:Client BugList Analysis.xltx|alt=Client Buglist Analysis.xltx|none|thumb]]
 == Exporting ==
@@ Line 60: / Line 64: @@
 The Analysis tab will break down the issues in the list and summarize the data.
 [[Category:Processes]]

Anw: Categorisation

2025-07-21T14:02:16Z

Categorisation

← Older revision		Revision as of 16:02, 21 July 2025
Line 60:		Line 60:

	The Analysis tab will break down the issues in the list and summarize the data.		The Analysis tab will break down the issues in the list and summarize the data.
			[[Category:Processes]]

Anw: Minor formatting change

2025-07-21T14:01:21Z

Minor formatting change

← Older revision		Revision as of 16:01, 21 July 2025
Line 35:		Line 35:


	Create a DevOps Bug List spreadsheet from template.		Create a DevOps Bug List spreadsheet from template.[[File:Client BugList Analysis.xltx\|alt=Client Buglist Analysis.xltx\|none\|thumb]]

	~~{{Warning}}Cross reference and provide template~~
	[[File:Client BugList Analysis.xltx\|alt=Client Buglist Analysis.xltx\|none\|thumb]]

	== Exporting ==		== Exporting ==

Anw: Updated

2025-07-21T14:00:30Z

Updated

← Older revision		Revision as of 16:00, 21 July 2025
Line 38:		Line 38:

	{{Warning}}Cross reference and provide template		{{Warning}}Cross reference and provide template
			[[File:Client BugList Analysis.xltx\|alt=Client Buglist Analysis.xltx\|none\|thumb]]

	== Exporting ==		== Exporting ==

Anw: Initial Creation

2025-07-21T13:58:17Z

Initial Creation

New page

The intention is to standardize the way that DevOps cases are documented, so that the issues list can identify rework bugs and what caused the issue.

== Using ==
Devops/Queries.

== Configuration ==
For reference, see Queries/Shared Queries/CTY/CTY Logs Entered by TW.

Create a query with the following columns:

* Title
* Assigned To
* State
* Sub state
* Priority
* Severity
* Created Date
* Tags
* Work Item Type
* Bug Type
* Fault
* Hotfix in Release

Add criteria to select the data, typically:

* Work Item Type - Any
* State - Any
* EITHER/BOTH/NEITHER - depending on requirements.
** Tags contains - select your tags
** Custom Customer Contains - Enter a part of the customer

If possible, use a shared query or create a shared query .

Create a DevOps Bug List spreadsheet from template.

{{Warning}}Cross reference and provide template

== Exporting ==
Run the Query.

Use the triple-dot menu on top right.

Choose Export to CSV

Open CSV

Copy all data (minus headers)

Open DevOps BugList spreadsheet

Paste data into first tab (DevOps Logs).

Go to second tab (Analysis)

Click Data/Refresh All.

Save.

The Analysis tab will break down the issues in the list and summarize the data.