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 |
---|---|
| Development System of the Transport |
| Transport GUID |
| Transport Number e.g. |
| Transport type
|
| SAP User ID of the Transport Owner |
| 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 |
| Customer Action that is entered as description in CC5 customizing |
| Followup system for the next import |
| Only for ToCs → Transport number of releated transport request |
| Only for ToCs → Transport Guid of releated transport request |
| 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