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'

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

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

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

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

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