\uD83D\uDCD8 JQL functions
requestsImportedToLevel(levelName, filter, isImported)
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 projectsForProperty("devSystems", "~", "NT1_100")
requestsImportedToSystem(system, filter, isImported)
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
\uD83D\uDCD8 Searchable issue properties
tmFilter_CREATION
value example: {content: ‘true’}
search example: issue.property[tmFilter_CREATION].content ~ 'true'
tmDestination
value example: {content: ‘Destination1,Destination2,Destination3’}
search example: 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’}
search example (issues not imported into ‘Quality’ level) : issue.property[levelName].content ~ 'Quality0'
search example (issues imported into ‘Quality’ level) : issue.property[levelName].content ~ 'Quality1' and issue.property[levelName].content !~ 'Quality0'
tmSystem
value example: {content: ‘SYD1, SYQ0, SYP0’}
search example (issues not imported into ‘SYQ0’ system): issue.property[tmSystem].content ~ 'SYP0'
search example (issues imported into ‘SYQ0’ system): issue.property[tmSystem].content ~ 'SYD1' and issue.property[tmSystem].content !~ 'SYD0'
tmRC
value example: {content: ‘0,8,13’}
search example: issue.property[tmRC].content ~ '13'
tmTransports
value example: {content: ‘SYD0009001,SYD0009002,SYD0009003’}
search example: issue.property[tmTransports].content ~ 'SYD0009001'
tmEnabled
value example: {content: ‘true’}
search example: issue.property[tmEnabled].content ~ 'true'
transportUpdated (UTC time zone)
value example: {updated: ‘Fri, 27 Jan 2023 08:33:33 GMT’}
search example: 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’)