Archived field in the component table may have null, N and Y values in Jira
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Jira's component table has a field named archived which is translated by Jira into the Status column on the project's Component page.
While the source of the null value on it is undetermined, this article is aimed at clarifying that only the 'Y'value translates into ARCHIVED.
When the archived the column is set as 'N' or null on the component table, you will have ACTIVE Status.
Example project components:
Respective
componenttable:
Was this helpful?