/
SmartChange JQL search functionalities for Cloud

SmartChange JQL search functionalities for Cloud

Owned by Alina Cucean tests stest etxsajmsazfhjsdmgjk,d.gmkl
Last updated: Dec 18, 2024 by Franz Hiltscher
2 min read

JQL functions

requestsImportedToLevel (levelName, filter, isImported)

Description

Searches for imported requests at a specific TM level.

Parameters

  • levelName (mandatory): The name of TM level

  • filter (optional): jql function to filter the results

  • isImported (optional): flag if search is for imported requests

Example of JQL

issue in requestsImportedToLevel("Quality", "project = TIF", "true")

 

requestsImportedToSystem(system, filter, isImported)

Description

Filters imported requests to a specific SAP system.

Parameters

  • system (mandatory): The name of SAP system

  • filter (optional): jql function to filter the results

  • isImported (optional): flag if search is for imported requests into the system

Example of JQL

issue in requestsImportedToSystem("MT3", "project = TIF", "true")

requestsOutsideOfDEVSystems(systems, filter, startAt, maxResults)

Description

Searches for requests outside specified development systems

Parameters:

  • systems (mandatory): The name of SAP development systems

  • filter (optional, recommended by Jira): jql function to filter the results

  • startAt and maxResults: For the jql to not run into timeout, these parameters will be used to loop through the list of issues

    • startAt: default start index is 0

  • maxResults: number of issues to fetch and query, default is 50.

Examples:

  • Development Systems are MT1, MT4 and NT1.

  • For a filter (“project = PJ1“) all issues are in total of 241, then loop through the the list

issue in requestsOutsideOfDEVSystems("MT1, MT4, NT1", "project = PJ1", 0) issue in requestsOutsideOfDEVSystems("MT1, MT4, NT1", "project = PJ1", 50) issue in requestsOutsideOfDEVSystems("MT1, MT4, NT1", "project = PJ1", 100) issue in requestsOutsideOfDEVSystems("MT1, MT4, NT1", "project = PJ1", 150) issue in requestsOutsideOfDEVSystems("MT1, MT4, NT1", "project = PJ1", 200)

Alternative run a single query

issue in requestsOutsideOfDEVSystems("MT1, MT4, NT1", "project = PJ1", 0) and issue in requestsOutsideOfDEVSystems("MT1, MT4, NT1", "project = PJ1", 50)…

  Searchable issue properties

tmFilter_CREATION

  • value example: {content: ‘true’}

issue.property[tmFilter_CREATION].content ~ 'true'

tmDestination

  • value example: {content: ‘Destination1,Destination2,Destination3’}

issue.property[tmDestination].content ~ 'Destination3'

tmProjects

  • value example: {content: ‘Project1,Project2,Project3’}

search example: issue.property[tmProject].content ~ 'Project2'

levelName

  • value example: {content: ‘Quality0,Quality1,Production0’}

(issues not imported into ‘Quality’ level) : issue.property[levelName].content ~ 'Quality0' (issues imported into ‘Quality’ level) : issue.property[levelName].content ~ 'Quality1' and issue.property[levelName].content !~ 'Quality0'

tmSystem

  • value example: {content: ‘SYD1, SYQ0, SYP0’}

(issues not imported into ‘SYQ0’ system): issue.property[tmSystem].content ~ 'SYP0' (issues imported into ‘SYQ0’ system): issue.property[tmSystem].content ~ 'SYD1' and issue.property[tmSystem].content !~ 'SYD0'

tmRC

  • value example: {content: ‘0,8,13’}

issue.property[tmRC].content ~ '13'

tmTransports

  • value example: {content: ‘SYD0009001,SYD0009002,SYD0009003’}

issue.property[tmTransports].content ~ 'SYD0009001'

tmEnabled

  • value example: {content: ‘true’}

issue.property[tmEnabled].content ~ 'true'

transportUpdated (UTC time zone)

  • value example: {updated: ‘Fri, 27 Jan 2023 08:33:33 GMT’}

issue.property[transportUpdated].updated~ 'Fri, 27 Jan 2023 08:33:33 GMT'

 

  Useful examples of JQLs

  • Get list of issues with the SmartChange panel active:

issue.property[tmEnabled].content ~ 'true'

  • Get list of issues with SAP transport requests:

issue.property[tmTransports].content ~ '*'

  • Get list of issues without SAP transport requests:

issue.property[tmEnabled].content ~'true' AND (issue.property[tmTransports].content IS EMPTY OR issue.property[tmTransports].content !~ '*')

  • Get list of issues with SAP transport requests imported into a TM level from project TIF:

issue in requestsImportedToLevel('Quality', ‘project = TIF and status !=Done')

  • Get list of issues with SAP transport requests not imported into an SAP system:

issue in requestsImportedToSystem('MT3', '', 'false’)

Related content