flowable / flowable-engine

A compact and highly efficient workflow and Business Process Management (BPM) platform for developers, system admins and business users.
https://www.flowable.org
Apache License 2.0
8.01k stars 2.63k forks source link

Unexpected result when querying tasks in Flowable 7.0.1 #3937

Open jin2001 opened 4 months ago

jin2001 commented 4 months ago

Hi all,

I have found what it could be a bug in the recent 7.0.1 version. When using taskService to query the running tasks, the query criterias are missing. So none of result is returned.

The code of query is as follows: query1: taskService.createTaskQuery().taskAssigned("user1") .taskState(Task.CREATED).list(); query2: taskService.createTaskQuery().taskAssigned("user1") .taskClaimedBefore("2024-07-29").list();

I expect the search is as follows: expectation1: assignee = "user1" AND STATE = "created" expectation2: assignee_ = "user1" AND CLAIMTIME < "2024-07-29"

But in the logs,the SQL generated is as follows: assignee_ = "user1"

The query criteria STATE_ and CLAIMTIME are missing.