...
| 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
| Note |
|---|
If you try to filter work log results using a JqlQuery by limiting the JqlResult to Issues containing a work log for a specific users, than consider, that the resulting list may contain work logs of other users as well. This is correct. Colloquial the questions has to be translated as follows:
|
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).
...