- About TestFLO
- Overview
- How to try
- Getting Started
- Onboarding
- Basic concepts
- Quick guide for Jira Administrator
- Quick guide for QA manager
- Quick guide for testers
- Demo environment
- User's guide
- Projects' organization
- Requirements
- Test design
- Organizing tests
- Test planning
- Test execution
- Automated test runs
- Import/Export TCT
- Operations
- Reporting and tracking
- Export test issues
- Issue search dialog
- TestFLO menu
- Admin's guide
- Project configuration
- Test Automation configuration
- TestFLO settings
- TestFLO Permissions
- Custom fields
- Advanced workflow configuration
- Panel Filter Result
- Upgrade reports
- Upgrade guide
- Integrations
- Confluence
- REST API
- Configuration Manager for Jira
JQL functions
This page provides information 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 |
testRepoTreeShallowSearch()
Returns a list of Test Case Templates from the given folder path from Test Repository tree.
- If you do not provide any project key then the search is performed in all Test Repository trees.
- If you provide an empty folder path or “/” as the first parameter then the search is performed in the root folder.
| JQL function | testRepoTreeShallowSearch("","") |
| arguments | a1= Full folder path from the Test Repository (string) b1= Project Key b2= Project Key ... bn= Project Key |
| sample query | key in testRepoTreeShallowSearch("Login") returns Test Case Templates from the specified folder path from Test Repositories in all projects
key in testRepoTreeShallowSearch("Component/Login","sample") returns Test Case Templates from the specified folder path from Test Repository in the given project |
testRepoTreeDeepSearch()
Returns a list of Test Case Templates from the given folder path and its subfolders from Test Repository tree.
- If you do not provide any project key then the search is performed in all Test Repository trees.
- If you provide an empty folder path or “/” as the first parameter then the search is performed in the root folder.
| JQL function | testRepoTreeDeepSearch("","") |
| arguments | a1= Full folder path from the Test Repository (string) b1= Project Key b2= Project Key ... bn= Project Key |
| sample query | key in testRepoTreeDeepSearch("Login") returns Test Case Templates from the specified folder path and its subfolders from Test Repositories in all projects
key in testRepoTreeDeepSearch("Component/Login","sample") returns Test Case Templates from the specified folder path and its subfolders from Test Repository in the given project |
