Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

\uD83D\uDCD8 JQL functions

  1. requestsImportedToLevel(levelName, filter, isImported)

    1. Parameters:

      1. levelName (mandatory): The name of TM level

      2. filter (optional): jql function to filter the results

      3. isImported (optional): flag if search is for imported requests

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

  2. requestsImportedToSystem(system, filter, isImported)

    1. Parameters:

      1. system (mandatory): The name of SAP system

      2. filter (optional): jql function to filter the results

      3. isImported (optional): flag if search is for imported requests into the system

\uD83D\uDCD8 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. levelName

    1. value example: {content: ‘Quality0,Quality1,Production0’}

    2. search example (issues not imported into ‘Quality’ level) : issue.property[levelName].content ~ 'Quality0'

    3. search example (issues imported into ‘Quality’ level) : issue.property[levelName].content ~ 'Quality1' and issue.property[levelName].content !~ 'Quality0'

  5. tmSystem

    1. value example: {content: ‘SYD1, SYQ0, SYP0’}

    2. search example (issues not imported into ‘SYQ0’ system): issue.property[tmSystem].content ~ 'SYP0'

    3. search example (issues imported into ‘SYQ0’ system): issue.property[tmSystem].content ~ 'SYD1' and issue.property[tmSystem].content !~ 'SYD0'

  6. tmRC

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

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

  7. tmTransports

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

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

  8. tmEnabled

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

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

  9. 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 a TM level from project TIF:

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

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

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

  • No labels