SmartChange JQL search functionalities for Server/Data Center
JQL functions
projectsForProperty
Parameters:
project property name
operator (“~”)
value of the property name
Example of JQL: issue in projectsForProperty("devSystems", "~", "NT1_100")
parent
Example of JQL: parent in parent("type= 'Task' AND status = 'Approved'")
rtImportedTR
Parameters:
level_name: imported into level
imported with error: if RC >= 8, default false, last = check latest TR
Example of JQL:
issue in rtImportedTR("Production")
issue in rtImportedTR("Production", “true”)
issue in rtImportedTR("Production", “last”)
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'
tmSystem
value example: {content: ‘SYD, SYQ, SYP’}
search example: issue.property[tmSystem].content ~ 'SYP'
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 an SAP system:
issue in rtImportedTR("Production")
Get list of issues with SAP transport requests not imported into an SAP system:
issue not in rtImportedTR("Production")