- Introduction
- About
- Onboarding
- Getting Started
- Demo backup
- User's guide
- Projects' organization
- Test design
- Test Repository
- Test execution
- Test planning
- Requirements
- Reporting and tracking
- Operations
- Import/Export Steps
- Issue search dialog
- Admin's guide
- Project configuration
- TestFLO settings
- TestFLO Permissions
- Custom fields
- Advanced workflow configuration
- Panel Filter Result
- REST API
- Imports/Exports
- Upgrade reports
- Upgrade guide
JQL functions
This page provides informations on how to serach test data with extended JQL functions.
The standard JQL may be insufficient, which is why dedicated JQL functions have been created. You will be able to quickly search and obtain important to analyze test data.
requirementsFromTCInTP()
Returns a list of unique issues set in Requirement field on Test Cases for a given Test Plan(s).
| JQL function | requirementsFromTCInTP("") |
| arguments | a1= Test Plan Issue Key a2= Test Plan Issue Key ... an= Test Plan Issue Key |
| sample query | issuekey in requirementsFromTCInTP("TP-68","TP-89","TP-166") |
steps
Returns a list of Test Case Template(s) and Test Case(s), where the Steps custom field contain the given word from the query.
| JQL function | steps |
| arguments | a1= word to search |
| sample query | steps ~ test |
templateInPlan()
Returns a list of Test Plan(s) in which certain Test Case Template(s) were used to create Test Case(s) for this Test Plan.
| JQL function | templateInPlan("","") |
| arguments | a1= ID of TC Template custom field b1= Test Case Template Issue Key b2= Test Case Template Issue Key ... bn= Test Case Template Issue Key |
| sample query | issuekey in templateInPlan("customfield_10005","TCT-1","TCT-2","TCT-3") |
templatesFromPlan()
Returns a list of Test Case Template(s) which were used to create Test Case(s) in a given Test Plan.
| JQL function | templatesFromPlan("") |
| arguments | a1= Test Plan Issue Key a2= Test Plan Issue Key ... an= Test Plan Issue Key |
| sample query | issuekey in templatesFromPlan("TP-1","TP-2","TP-3") |
unusedTCT()
Returns a list of Test Case Template(s) which weren’t used in any Test Plan.
| JQL function | unusedTCT() |
| sample query | issuekey in unusedTCT() |
requirementsWithDefects()
Returns a list of Requirements conected with Defects which have specific parameters.
| JQL function | requirementsWithDefects("","") |
| arguments | a1= Defect Priority b1= Defect Resolution |
| sample query | key in requirementsWithDefects("","") returns all requirements with defects with all possible priorities and resolutions
key in requirementsWithDefects("High","Resolved") returns all requirements with defects which have "High" priority and are resolved |
