When REST without optional project result in ORA-01795:

[ipoppo]

When call REST API without optional project e.g. http://jira/rest/jira-worklog-query/1.2.1/find/worklogs?startDate=2017-08-01&endDate=2017-08-01&user=someusers

Result in following error:

ORA-01795: maximum number of expressions in a list is 1000

SQL statement is checked with JavaMelody.

SELECT worklog.id, worklog.startdate, worklog.issueid, worklog.author, worklog.timeworked, worklog.worklogbody, worklog.updated FROM worklog, jiraissue WHERE worklog.issueid=jiraissue.id AND worklog.startdate>=? AND worklog.startdate<? AND worklog.author IN (?) AND jiraissue.project IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,...)

The SQL is compiled to include all project in JIRA system instead of omitted WHERE clause.

        .where(intervalPredicate
            .and(worklog.author.in(userKeys))
>>         .and(issue.project.in(projectIds)))
        .orderBy(worklog.id.asc())

[bordatesz]

Hello there,
I see you have more than 1k Jira project. Unfortunetly, Oracle databases has a limit of 1k so you should narrow your search somehow. We'll think about how to improve the query, but since it is an open source project, we'll be happy to accept any improvement.

[ipoppo]

Added pull request #51

[daniel-toth-everit]

Hi @ipoppo !
Thanks for the PR. I will check it as soon as possible.

[ipoppo]

Since I have to compile for JIRA 5.x too, I have also push 1.2.x to my repo. If you want to merge my patch please create branch 1.2.x and tomorrow I will submit the changes.