Important note Retirement of icTime and Retirement of biz on December 29th, 2023
Using JQL Queries in Reporting
- iConcept Support
- iConcept Admin
Starting from ictime version 5.8.2 usage of JQL Queries in combination with the available report filters (drop downs) is supported.
How to enable JQL Support prior 5.8.2 (starting from 5.8.1.10)
This feature will be enabled by default in versions >= 5.8.2.
To enable this functionality (experimental) in versions prior 5.8.2, please navigate to
Administration / Add Ons /Manage Add Ons
Filter for ictime and open Add On Details. Click on "Modules" and enable the following module:
You can enable / disable the module any time
Combining JQL Query with other Filters
| Filter by Name | Can be combined with JQL | Filter Level | Remarks |
|---|---|---|---|
| From Date |  | work log (jira) | |
| To Date | | work log (jira) | |
| Filter |  | issue | Filters (from the filter field in the upper left corner) can not be combined with JQL queries to filter for reporting results. |
| Issue | | issue | |
| Projects | | issue | |
| Components | | issue | Components depend on the selected projects in ictime Projects drop down. If none of the selected projects does not have valid component definitions, no components will be displayed nor can be choosen and vice versa. |
| Fix Version | | issue | Behaviour for Fix Versions is analog to Components: No definition in drop down in any selected project(s), no filter for Fix Version can be applied. |
| Teams | | work log (ictime) | Behavior for Teams is analog to Fix Version and/or Components. |
| Users | | work log (jira) | If no project is selected all users will be display in the drop down. If at least one project is selected, the user drop down will be limited to the users with access to the projects choosen. |
| Activity Types | | work log (ictime) | |
| Issue Status | | issue | |
| Issue Type | | issue | |
| Approval / Accounting | | work log (ictime) | |
| Organizations | | issue (JSD) | |
| WLA / CF | |
|
Understanding using JqlQuery in Reporting
The result of any JqlQuery in Jira/JSD is a list of issues. If you are using a JqlQuery in icTime Reporting, than you should be aware that you are - in general - interested in getting work logs. To achieve this, you should know how reporting in icTime works when using a filter or a JqlQuery:
- in the first step icTime collects all issues which are returned by the filter / JqlQuery
- in the next step, icTime iterates over the found issues
- for each issue icTime iterates over work logs which have been collected and applies the filters on work log level (either Jira or icTime table, depending on the filter)
- if any filter is violated, the work log is discarded
If you try to filter work log results using a JqlQuery by limiting the JqlResult to Issues containing a work log for a specific user, than please consider: The resulting list may contain work logs of other users as well.
This is correct. Colloquial the questions has to be translated as follows:
- give me all Issues where a work log exists, which belongs to user xy (Jql Query)
- give me all work logs for the issues from previous step
- if you haven't applied the icTime user dropdown filter, you may see results of other users than xy as well
JQL Syntax parsing Check
There is a JQL syntax parsing check active in the JQL filter field while writing a query. Once the query can be validated (no syntax errors) a green icon is visible in the query field. If syntax checks fails, a red icon is displayed (see screen shots).
| Valid Query | Invalid Query |
|---|---|
 |
|
Getting Help with JQL Query Syntax
JQL Query Suggestion Support (help for functions, operators and operands) is not provided in this interface. If you need support writing JQL queries, please head to Jira advanced issue search interface. There you will find a JQL query builder which will suggest possible functions, operators and operands while writing a query. Once your query is providing the correct results, copy and paste it in the JQL query field in ictime reporting and execute it there.
Enhancements scheduled
In one of the next versions of ictime we will provide the possibility to choose from a list of last n applied JQL queries to be reexecuted.