/
SmartChange JQL search functionalities for Server/Data Center

SmartChange JQL search functionalities for Server/Data Center

JQL functions

projectsForProperty(propertyName, operator, value)

Description

Searches for issues where a SAP project property matches a given value.

Parameters

  • propertyName (mandatory): The name of the project property (e.g. devSystems)

  • operator (mandatory): The operator to use (e.g. “~” for contains)

  • value (mandatory): The value to match against the property

Example of JQL

issue in projectsForProperty("devSystems", "~", "NT1_100")

 

parent(jql)

Description

Searches for issues whose parent matches the given JQL filter.

Parameters

  • jql (mandatory): JQL expression to filter parent issues

Example of JQL

parent in parent("type = 'Task' AND status = 'Approved'")

 

rtImportedTR(levelName, importedWithError, last)

Description

Searches for issues with transport requests imported into a specific TM level.

Parameters

  • levelName (mandatory): The name of the TM level

  • importedWithError (optional): Set to “true” to include only transports imported with error (RC >= 8). Default: false

  • last (optional): Set to “last” to check the latest transport request only

Examples 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’}

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’}

issue.property[tmProject].content ~ 'Project2'

tmSystem

  • value example: {content: ‘SYD,SYQ,SYP’}

issue.property[tmSystem].content ~ 'SYP'

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 transport requests imported into a TM level:

issue in rtImportedTR("Production")

  • Get list of issues with transport requests not imported into a TM level:

issue not in rtImportedTR("Production")

On this page