Extend Task Json Query

lttung — Thu, 18 May 2017 02:59:45 -0400

I have a Task Query as json to filter tasks by states: SUSPENDED, RESUMED, PARKED and order by priority:

TaskQuery stateQuery = TaskQuery.create().where().state().isEqual(TaskState.SUSPENDED).or().state().isEqual(TaskState.RESUMED).or().state().isEqual(TaskState.PARKED).orderBy().priority();

After that, I would like to extend this query: filtering by ((suspended or resumed or parked states) and applicationId) order by priority but it is not as my expectation:

Way 1: TaskQuery.fromJson(stateQueryJson).where().and().applicationId().isEqual(1);

The result: SELECT * FROM IWA_Task WHERE (Column(IWA_TaskQuery.State) = 4 || Column(IWA_TaskQuery.State) = 5 || (Column(IWA_TaskQuery.State) = 8 && Column(IWA_TaskQuery.ApplicationId) = 1)) ORDER BY Column(CurrentPriority) ASCENDING

==> Tasks with Suspended state and Resumed state are not filtered by applicationId

Way 2: TaskQuery.create().where().and(TaskQuery.fromJson(stateQuery.asJson())).and().applicationId().isEqual(1)

The result: SELECT * FROM IWA_Task WHERE ((Column(IWA_TaskQuery.State) = 4 || Column(IWA_TaskQuery.State) = 5 || Column(IWA_TaskQuery.State) = 8) && Column(IWA_TaskQuery.ApplicationId) = 1)

==> Priority order is lost

Do you have any suggestions? Or is it a bug of task json query?

Questions Tagged With ivy

Extend Task Json Query