Assets Attributes
The Assets Attributes additional export populates 5 tables in Snowflake1:
Table Details
S4J_ASSETS_ATTRIBUTES
This table contains the main information related to Asset Attributes in Jira. All Asset Attribute information available from Jira is stored in this table. One instance of this table is created per configured export location. All exports with the Assets Attributes additional export option selected will merge asset attribute information into this table. For this reason, it is generally recommended that this option only be selected for one export per location. Otherwise export processes may perform duplicate work. Custom/scheduled updates to exports will only merge in asset attributes that have changed since the last update.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
WORKSPACEID | VARCHAR | Asset attribute’s workspace ID |
GLOBALID | VARCHAR | Asset attribute’s global ID |
ATTRIBUTEID | VARCHAR | Asset attribute’s ID |
OBJECTTYPEATTRIBUTEGLOBALID | VARCHAR | Attribute’s object type attribute global ID |
OBJECTTYPEATTRIBUTEID | VARCHAR | Attribute’s object type attribute ID |
NAME | VARCHAR | Attribute name |
LABEL | VARCHAR | Attribute label |
TYPE | INT | Attribute type ID |
DESCRIPTION | VARCHAR | Attribute description |
DEFAULTTYPEID | INT | Attribute default type ID |
DEFAULTTYPENAME | VARCHAR | Attribute default type name |
TYPEVALUE | VARCHAR | Attribute type value |
TYPEVALUEMULTI | ARRAY | Array of values for multi type attributes |
EDITABLE | BOOLEAN | Flag indicating whether attribute is editable |
SYSTEM | BOOLEAN | Flag indicating whether attribute is a system attribute |
SORTABLE | BOOLEAN | Flag indicating whether attribute is sortable |
SUMMABLE | BOOLEAN | Flag indicating whether attribute is summable |
INDEXED | BOOLEAN | Flag indicating whether attribute is indexed |
REMOVABLE | BOOLEAN | Flag indicating whether attribute is removable |
HIDDEN | BOOLEAN | Flag indicating whether attribute is hidden |
UNIQUEATTRIBUTE | BOOLEAN | Flag indicating whether attribute is unique |
INCLUDECHILDOBJECTTYPES | BOOLEAN | Flag indicating whether attribute includes child object types |
MINIMUMCARDINALITY | INT | Attribute’s minimum cardinality |
MAXIMUMCARDINALITY | INT | Attribute’s maximum cardinality |
SUFFIX | VARCHAR | Attribute suffix |
REGEXVALIDATION | VARCHAR | Regex used when validating attribute |
IQL | VARCHAR | IQL used for attribute |
QLQUERY | VARCHAR | QL query used for attribute |
OPTIONS | VARCHAR | Attribute options |
POSITION | INT | Attribute position/index |
S4J_ASSETS_ATTRIBUTES_REFERENCE_TYPES
This table contains information about the reference types of assets attributes.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
WORKSPACEID | VARCHAR | Asset attribute reference type workspace ID |
GLOBALID | VARCHAR | Asset attribute reference type global ID |
REFERENCETYPEID | VARCHAR | Asset attribute reference type ID |
NAME | VARCHAR | Asset attribute reference type name |
DESCRIPTION | VARCHAR | Asset attribute reference type description |
COLOR | VARCHAR | Asset attribute reference type color |
URL16 | VARCHAR | Asset attribute reference type icon URL |
REMOVABLE | BOOLEAN | Flag indicating whether reference type is removable |
OBJECTSCHEMAID | VARCHAR | Asset attribute object schema ID |
S4J_ASSETS_ATTRIBUTES_REFERENCE_OBJECTS
This table contains information about the reference objects of assets attributes.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
WORKSPACEID | VARCHAR | Asset attribute reference object workspace ID |
GLOBALID | VARCHAR | Asset attribute reference object global ID |
REFERENCEOBJECTID | VARCHAR | Asset attribute reference object ID |
NAME | VARCHAR | Asset attribute reference object name |
LABEL | VARCHAR | Asset attribute reference object label |
OBJECTKEY | VARCHAR | Asset attribute reference object key |
CREATED | DATETIME | Asset attribute reference object creation timestamp |
UPDATED | DATETIME | Asset attribute reference object update timestamp |
HASAVATAR | BOOLEAN | Flag indicating whether the asset attribute reference object has an avatar |
AVATARWORKSPACEID | VARCHAR | Asset attribute reference object avatar’s workspace ID |
AVATAROBJECTID | VARCHAR | Asset attribute reference object avatar’s object ID |
AVATARURL16 | VARCHAR | Asset attribute reference object avatar’s icon URL |
TIMESTAMP | INT | Asset attribute reference object timestamp |
S4J_ASSETS_ATTRIBUTES_OBJECT_TYPES
This table contains information about the object types of assets attributes.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
WORKSPACEID | VARCHAR | Asset attribute object type workspace ID |
GLOBALID | VARCHAR | Asset attribute object type global ID |
OBJECTTYPEID | VARCHAR | Asset attribute object type ID |
NAME | VARCHAR | Asset attribute object type name |
TYPE | VARCHAR | Asset attribute object type |
DESCRIPTION | VARCHAR | Asset attribute object type description |
ICONID | VARCHAR | Asset attribute object type icon ID |
ICONNAME | VARCHAR | Asset attribute object type icon name |
ICONURL16 | VARCHAR | Asset attribute object type icon URL |
POSITION | INT | Asset attribute object type position |
CREATED | DATETIME | Asset attribute object type creation timestamp |
UPDATED | DATETIME | Asset attribute object type update timestamp |
OBJECTCOUNT | INT | Asset attribute object type count |
PARENTOBJECTTYPEID | VARCHAR | Asset attribute object type parent object type ID |
OBJECTSCHEMAID | VARCHAR | Asset attribute object type object schema ID |
INHERITED | BOOLEAN | Flag indicating whether asset attribute object type is inherited |
ABSTRACTOBJECTTYPE | BOOLEAN | Flag indicating whether asset attribute object type is abstract |
PARENTOBJECTTYPEINHERITED | BOOLEAN | Flag indicating whether asset attribute parent object type is inherited |
S4J_ASSETS_ATTRIBUTES_VALUES
This table contains information about the values associated with assets attributes.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
WORKSPACEID | VARCHAR | Asset attribute value workspace ID |
ASSETGLOBALID | VARCHAR | Asset attribute’s asset global ID |
ASSETID | VARCHAR | Asset attribute’s asset ID |
ATTRIBUTEGLOBALID | VARCHAR | Asset attribute global ID |
ATTRIBUTEID | VARCHAR | Asset attribute ID |
VALUE | VARCHAR | Asset attribute value (raw) |
VALUESTRING | VARCHAR | Asset attribute value (string) |
VALUEJSON | VARIANT | Asset attribute value (JSON) |
SEARCHVALUE | VARCHAR | Asset attribute value’s search value |
DISPLAYVALUE | VARCHAR | Asset attribute value’s display value |
REFERENCEDTYPE | BOOLEAN | Flag indicating whether this value uses a referenced type |
REFERENCETYPEWORKSPACEID | VARCHAR | Attribute value reference type workspace ID |
REFERENCETYPEGLOBALID | VARCHAR | Attribute value reference type global ID |
REFERENCETYPEID | VARCHAR | Attribute value reference type ID |
REFERENCEDOBJECTWORKSPACEID | VARCHAR | Attribute value’s referenced object workspace ID |
REFERENCEDOBJECTGLOBALID | VARCHAR | Attribute value’s referenced object global ID |
REFERENCEDOBJECTID | VARCHAR | Attribute value’s referenced object ID |
1This additional export option’s data references Assets. For this reason, the table(s) populated by the Assets export option will also be populated by this option. See the Assets export option tables for more information.