SmartChange JQL search functionalities for Cloud

 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 requestsImportedToLevel("Quality", "project = TIF", "true")

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

   2. Example of JQL: issue in requestsImportedToSystem("MT3", "project = TIF", "true")

 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'