SmartChange JQL search functionalities for Server/Data Center

 JQL functions

  1. projectsForProperty

    1. Parameters:

      1. project property name

      2. operator (“~”)

      3. value of the property name

    2. Example of JQL: issue in projectsForProperty("devSystems", "~", "NT1_100")

  2. parent

    1. Example of JQL: parent in parent("type= 'Task' AND status = 'Approved'")

  3. rtImportedTR

    1. Parameters:

      1. level_name: imported into level

      2. imported with error: if RC >= 8, default false, last = check latest TR

    2. Example of JQL:

      1. issue in rtImportedTR("Production")

      2. issue in rtImportedTR("Production", “true”)

      3. issue in rtImportedTR("Production", “last”)

 Searchable issue properties

  1. tmFilter_CREATION

    1. value example: {content: ‘true’}

    2. search example: issue.property[tmFilter_CREATION].content ~ 'true'

  2. tmDestination

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

    2. search example: issue.property[tmDestination].content ~ 'Destination3'

  3. tmProjects

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

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

  4. tmSystem

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

    2. search example: issue.property[tmSystem].content ~ 'SYP'

  5. tmRC

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

    2. search example: issue.property[tmRC].content ~ '13'

  6. tmTransports

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

    2. search example: issue.property[tmTransports].content ~ 'SYD0009001'

  7. tmEnabled

    1. value example: {content: ‘true’}

    2. search example: issue.property[tmEnabled].content ~ 'true'

  8. transportUpdated (UTC time zone)

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

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

 

Useful examples of JQLs

  1. Get list of issues with the SmartChange panel active:

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

  2. Get list of issues with SAP transport requests:

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

  3. 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 !~ '*')

  4. Get list of issues with SAP transport requests imported into an SAP system:

    • issue in rtImportedTR("Production")

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

    • issue not in rtImportedTR("Production")