Issue Properties

Definitions

In order to search for transport details, we added the transport details in the Issue Properties to CC5 Application. With the properties you have the opportunity to create consistency checks with scriptrunner or to search for transport details via JQL statements.

This feature is currently only available for CC5 DC.

 

  • The following properties are available for a Transport Request (if applicable for a given TR)

Issue Property Key

Description

Issue Property Key

Description

  • devSystem

Development System of the Transport

  • trGuid

Transport GUID

  • trNumber

Transport Number e.g. SMEK904221

  • trType

Transport type

  • Customizing

  • Workbench

  • T → Transport of Copies

  • trOwner

SAP User ID of the Transport Owner

  • trStatus

Transport status. The following transport status are available:

D → Modifiable

L → Locked

O → Release started

R → Released

N → Released (Import protection for repaired objects active)

W → Waiting for Import in DEV

I → Imported into DEV

Q → Imported into QAS

P → Imported into Production

F → Import failed

J → Import running

  • customerAction

Customer Action that is entered as description in CC5 customizing

  • nextSystem

Followup system for the next import

  • parentNumber

Only for ToCs → Transport number of releated transport request

  • parentGuid

Only for ToCs → Transport Guid of releated transport request

  • lastRefresh

Last refresh of ticket

The Issue properties will only be present and consistent for an existing Jira issue after clicking “Sync” once after upgrading into this feature.

 

cc5-tr-sync-pretty

There are two types of issue properties available:

  • `cc5-tr-sync-pretty`

    • Example below

    • lists a list of TRs, each with their own data

    • for use with e.g. scriptrunner

{ "key": "cc5-tr-sync-pretty", "value": [ { "devSystem": "SME~ABAP/800", "trGuid": "00155D19030F1EEF90D5D41BCE6BCB1F", "trNumber": "SMEK904221", "trType": "Customizing", "trOwner": "WENZELM", "trStatus": "D", "customerAction": "iinitial", "nextSystem": "SME~ABAP/801", "lastRefresh": "15.07.2024 15:50:02" }, { "devSystem": "SME~ABAP/800", "trGuid": "00155D19030F1EEF90D5D4230DF36B1F", "trNumber": "SMEK904223", "trType": "Workbench", "trOwner": "WENZELM", "trStatus": "D", "customerAction": "iinitial", "nextSystem": "SME~ABAP/801", "lastRefresh": "15.07.2024 15:50:02" }, { "devSystem": "SME~ABAP/800", "trGuid": "00155D19030F1EEF90D5D6F8F4A34B1F", "trNumber": "SMEK904225", "trType": "T", "trOwner": "WENZELM", "trStatus": "Q", "customerAction": "iimport", "nextSystem": "SME~ABAP/803", "parentNumber": "SMEK904223", "parentGuid": "00155D19030F1EEF90D5D4230DF36B1F", "lastRefresh": "15.07.2024 15:50:02" } ] }

 cc5-tr-sync

  • `cc5-tr-sync`

    • has the previously stated fields with a trailing (e.g. `trGuids` or `trStatuss`)

    • for every TR, their value for the respective field is added to a long string, seperated with semicolon(;)

    • can be used in JQL, as these fields are indexed for searches

    • can also be used for Scriptrunner, but the “pretty” version should be used and prefered where possible 

{ "key": "cc5-tr-sync", "value": { "devSystems": "SME~ABAP/800;SME~ABAP/800;SME~ABAP/800;", "trGuids": "00155D19030F1EEF90D5D6F8F4A34B1F;00155D19030F1EEF90D5D41BCE6BCB1F;00155D19030F1EEF90D5D4230DF36B1F;", "trNumbers": "SMEK904225;SMEK904221;SMEK904223;", "trTypes": "T;Customizing;Workbench;", "trOwners": "WENZELM;WENZELM;WENZELM;", "trStatuss": "Q;D;D;", "customerActions": "iimport;iinitial;iinitial;", "nextSystems": "SME~ABAP/803;SME~ABAP/801;SME~ABAP/801;", "parentNumbers": "SMEK904223;null;null;", "parentGuids": "00155D19030F1EEF90D5D4230DF36B1F;null;null;", "lastRefreshs": "15.07.2024 15:50:02;15.07.2024 15:50:02;15.07.2024 15:50:02;" } }

 

JQL Use cases

In order to search for transport details, you can enter a JQL statement as follows. You need to start always with “issue.property[cc5-tr-sync].” and then add the desired search criteria with the value. Please find some JQL Examples below:

issue.property[cc5-tr-sync].trNumbers ~ "SMEK904225"

Returns all Jira issues that have this transport listed

Supports wildcard operator likes this

issue.property[cc5-tr-sync].trNumbers ~ "SME*"

 

issue.property[cc5-tr-sync].trTypes ~ "Workbench"

Allows you to see all issues with workbench requests assigned to it

 

issue.property[cc5-tr-sync].trOwners ~ "WENZELM"

Rerturns a list of issues with a certain transport owner