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	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	work log (ictime) [WLA] issue 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.

Browser not supported