Questions Tagged With task-query

show sql query when query ivy task

maidanh — Fri, 27 Jul 2018 04:55:35 -0400

Dear IvyTeam

How can I print sql query to log file when there are some get ivy task by query?

I followed this link https://answers.axonivy.com/questions/1585/hibernate-show_sql but it seem for project that using hibernate?

If I print query by method TaskQuery query.toString() I got some kind of query in log but it's not friendly with normal sql like below

SELECT *  
  FROM IWA_Task  
  LEFT JOIN IWA_TaskAdditionalProperty TaskAddPrp_isDeleted ON Column(IWA_TaskQuery.TaskId) = Column(IWA_TaskAdditionalProperty.TaskId)
  LEFT JOIN IWA_AdditionalProperty AddPrpTask_isDeleted ON Column(TaskAddPrp_isDeleted.AdditionalPropertyId) = Column(IWA_AdditionalProperty.AdditionalPropertyId)
  INNER JOIN IWA_CaseQuery ON (Column(IWA_CaseQuery.CaseId) = Column(IWA_TaskQuery.CaseId) || Column(IWA_CaseQuery.CaseId) = Column(IWA_TaskQuery.BusinessCaseId))
  LEFT JOIN IWA_CaseAdditionalProperty CaseAddPrp_taskType ON Column(IWA_Case.CaseId) = Column(IWA_CaseAdditionalProperty.CaseId)
  LEFT JOIN IWA_AdditionalProperty AddPrpCase_taskType ON Column(CaseAddPrp_taskType.AdditionalPropertyId) = Column(IWA_AdditionalProperty.AdditionalPropertyId)
  WHERE (Column(IWA_TaskQuery.CurrentActivatorName) NOT LIKE #SYSTEM && Column(IWA_TaskQuery.State) <> 3 && (((Column(AddPrpTask_isDeleted.Name) = isDeleted || Column(AddPrpTask_isDeleted.Name) IS NULL) && Column(AddPrpTask_isDeleted.Value) IS NULL) || ((Column(AddPrpTask_isDeleted.Name) = isDeleted || Column(AddPrpTask_isDeleted.Name) IS NULL) && Column(AddPrpTask_isDeleted.Value) NOT LIKE true)) && (Column(IWA_TaskQuery.CurrentActivatorUserId) = 64104 || (! Column(IWA_Task.State) = 3 && (Column(IWA_Task.ActivatorRoleId) = 204 || (Column(IWA_Task.IsExpired) = 1 && Column(IWA_Task.ExpiryActivatorRoleId) = 204))) || (! Column(IWA_Task.State) = 3 && (Column(IWA_Task.ActivatorRoleId) = 205 || (Column(IWA_Task.IsExpired) = 1 && Column(IWA_Task.ExpiryActivatorRoleId) = 205))) || (! Column(IWA_Task.State) = 3 && (Column(IWA_Task.ActivatorRoleId) = 902 || (Column(IWA_Task.IsExpired) = 1 && Column(IWA_Task.ExpiryActivatorRoleId) = 902)))) && (Column(IWA_TaskQuery.State) = 4 || Column(IWA_TaskQuery.State) = 5 || Column(IWA_TaskQuery.State) = 8) && ((Column(AddPrpCase_taskType.Name) = taskType || Column(AddPrpCase_taskType.Name) IS NULL) && Column(AddPrpCase_taskType.Value) LIKE CONTINUE_CREATE_KLARAHOME_COMPANY))

Do you have any idea about it? How can I print sql?

TaskQuery with additional property

dolong — Tue, 06 Jun 2017 06:25:16 -0400

Hi everyone,

I have the issue related to additional property in TaskQuery: Task A doesn't have any additional property and Task B has the "DISPLAY" additional property.

TaskQuery stateQuery = TaskQuery.create().where().state().isEqual(TaskState.SUSPENDED).or().state().isEqual(TaskState.RESUMED).or().state().isEqual(TaskState.PARKED);
TaskQuery additionalPropertyQuery = TaskQuery.create().where().additionalProperty("HIDE").isNull();
TaskQuery query = TaskQuery.create().where().and(stateQuery).and(additionalPropertyQuery);

==> The result of this query is only Task A. I expect that the result is A and B.

Do you have any suggestions?

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?

Query Task's Business - Task stage

rhorber — Fri, 03 Feb 2017 08:30:42 -0500

In the "Inscribe Task Switch Event" under tab "Tasks" there is a tab "Business". The first two fields are labeled "Task stage".
Is there a Pulic API to query these two fields?

findWorkTasks() never returns tasks in TaskState.RESUMED state

Jailson Brito — Wed, 01 Feb 2017 15:45:36 -0500

Hello.

Using engine 6.0.5, I am trying to query tasks that the session user is working or can work on.

According to the docs, findWorkTasks() can return tasks in states TaskState.SUSPENDED, TaskState.CREATED, TaskState.RESUMED, TaskState.PARKED.

When I use it like this:

result = ivy.session.findWorkTasks(filter, order, first, pageSize, true, EnumSet.of(TaskState.SUSPENDED, TaskState.RESUMED));

It never returns TaskState.RESUMED tasks, only TaskState.SUSPENDED.

Just to double check if I have resumed tasks, I tried the following call and it returns the TaskState.RESUMED tasks. result = ivy.session.findLockedWorkTasks(filter, order, first, pageSize, true, EnumSet.of(TaskState.RESUMED));

What am I doing wrong on my use of findWorkTasks()?

Thanks in advance,

Globale Task List

Florian Hitz — Wed, 16 Mar 2016 15:55:10 -0400

Hi I would like to have a Tasklist with all Tasks that are allocated to Users, without System Tasks. I tried something, but it wont work:

IQueryResult queryResult  = ivy.wf.findTasks(null, PropertyOrder.create(TaskProperty.START_TIMESTAMP, OrderDirection.ASCENDING), 0, -1, true);

I am getting a PermissionDeniedException.

Best regards Florian

TaskQuery case insensitive search

Emmanuel — Fri, 14 Aug 2015 16:36:27 -0400

Hi all,

Is it possible to search against String Task properties with a TaskQuery so that the search is performed case insensitive.


    TaskQuery stringFieldQuery = TaskQuery.create();
    stringFieldQuery.where().name().isLike("my task name");

I would like that such a query returns the tasks which name is "MY Task NAme". Thanks in advance

Emmanuel

TaskQuery for description search

Emmanuel — Tue, 09 Jun 2015 11:50:46 -0400

Hi all,

Is that possible to make a search for tasks by their description? A search by name is possible through:

TaskQuery stringFieldQuery = TaskQuery.create();
stringFieldQuery.where().name().isLike("search by name");

I guessed it was the same for the description but it seems to be unpossible to do such a TaskQuery for the description because the following code returns an IColumnFilterQuery and not an IStringColumnFilterQuery as for the name():

stringFieldQuery.where().description() // There is no isLike("...") method then.

Is there another possibility with the TaskQuery?

Thanks in advance

Emmanuel

TaskQuery isInvolved and canWorkOn

Emmanuel — Fri, 29 May 2015 15:25:40 -0400

Hello,

What does mean isInvolved for a SecurityMember in a TaskQuery? If I want to get all the tasks that I can start, is "canWorkOn" enough?

Thanks a lot in advance!

Example:

ISecurityMember member = Ivy.wf().getSecurityContext().findUser(username);

TaskQuery taskUserQuery = TaskQuery.create();
taskUserQuery.where().isInvolved(member);
taskUserQuery.where().or().canWorkOn(member);

`TaskQuery.and(TaskQuery)` and `CaseQuery.and(CaseQuery)` doesn't work with `additionalProperty()`.

Genzer Hawker — Wed, 27 May 2015 09:04:31 -0400

On our project, we extensively uses the API TaskQuery and CaseQuery in order to find ITask and ICase respectively. We also make use of the additionalProperty of both ITask and ICase in order to store custom fields.

However, we later found out that the method and(TaskQuery and or(TaskQuery) doesn't work with the criteria additionalProperty.

Consider the below snippet of code:

public List<ITask> findTask() {
    Ivy.wf().getTaskQueryExecutor()
            .getResults(TaskQuery.create().where()
                    .state().isEqual(SUSPENDED)
                    .and(hasCustomField()));
}

private static TaskQuery hasCustomField() {
    return TaskQuery.create().where().additionalProperty("custom").isLike("customized_value");
}

Runing the code will result as an exception:

java.sql.SQLException: Column not found: ADDITIONALPROPERTYFORTASK.NAME in statement [SELECT IWA_TASKQUERY.TASKID ....... FROM IWA_TaskQuery WHERE (IWA_TASKQUERY.APPLICATIONID = ? AND (IWA_TASKQUERY."STATE" = ? AND ((ADDITIONALPROPERTYFORTASK.NAME = ? OR ADDITIONALPROPERTYFORTASK.NAME IS NULL) AND ADDITIONALPROPERTYFORTASK."VALUE" LIKE ?))) ORDER BY IWA_TASKQUERY.TASKID ASC]

While this works:

public List<ITask> findTask() {
    Ivy.wf().getTaskQueryExecutor()
            .getResults(TaskQuery.create().where()
                    .state().isEqual(SUSPENDED)
                    .and().additionalProperty("custom").isLike("customized_value");
}

Please note that only the criterion additionalPropety() has this problem, the other criteria don't.

Digging a little deeper, I found that the queries produced are different:

The former (the problematic one) produces:

SELECT * FROM IWA_Task WHERE
 (Column(IWA_TaskQuery.State) = 4 &amp;&amp;
 ((Column(AdditionalPropertyForTask.Name) = custom || Column(AdditionalPropertyForTask.Name) IS NULL)
    &amp;&amp; Column(AdditionalPropertyForTask.Value) LIKE customized_value))

...whereas the latter produces (correctly):

SELECT *  FROM IWA_Task 
LEFT JOIN IWA_TaskAdditionalProperty ON Column(IWA_TaskQuery.TaskId) = Column(IWA_TaskAdditionalProperty.TaskId)
LEFT JOIN IWA_AdditionalProperty ON Column(IWA_TaskAdditionalProperty.AdditionalPropertyId) = Column(IWA_AdditionalProperty.AdditionalPropertyId)
WHERE (Column(IWA_TaskQuery.State) = 4 && (Column(AdditionalPropertyForTask.Name) = custom || Column(AdditionalPropertyForTask.Name) IS NULL) && Column(AdditionalPropertyForTask.Value) LIKE customized_value)

This problem occurs both on TaskQuery and CaseQuery and on Axon.ivy 5.1.x (additionalProperty() has been introduced since 5.1.x).

I think this is probrably a bug in Axon.ivy query API. While there is a work-around (don't use and(TaskQuery with additionalProperty()), I think it is not good to have inconsistency in the API. I hope this would be fixed soon.

I have created a demo project which can reproduce the problem on Axon.ivy. Download it at box.net.