Curious issue when querying the BUG table

  • Questions
  • Curious issue when querying the BUG table
Question ID: 107991
1
0

While creating some SQL for reporting I noticed that the SQL returns 1 result where the BG_RESPONSIBLE field is NULL.
The BG_RESPONSIBLE field is required during DEFECT creation.
I’m curious why this is occurring…

SELECT [BG_BUG_ID]
,[BG_STATUS]
,[BG_DETECTION_DATE]
,[BG_RESPONSIBLE]
FROM [default_rpm_db].[dbo].[BUG]
WHERE BG_DETECTION_DATE BETWEEN ‘2017-09-11’ AND ‘2017-09-15’

Marked as spam
Posted by (Questions: 113, Answers: 8)
Asked on November 1, 2017 1:24 am
8 views
Answers (1)
1
Private answer

The BG_RESPONSIBLE field is actually the ''Assigned To:'' field in the Defect Details. By default, this is not a required field and you cannot make changes to system fields using the GUI. You could use workflow or the ''Script Generator - Defect Details Field Customization'' to change it to a required field. If you have not changed the properties for this field then the NULL value is valid.

Marked as spam
Posted by (Questions: 0, Answers: 310)
Answered on November 1, 2017 1:26 am
Oh I don't know how I missed that. The Assigned To field is not a required field.
( at November 1, 2017 1:27 am)