topic Re: Getting local task variable with Native Queries in Alfresco Archive

Getting local task variable with Native Queries

rohitagrawal — Tue, 24 Dec 2013 10:05:56 GMT

Hi,When use taskQuery with "includeTaskLocalVariables" i can get all task local variables.But when i am using taskNativeQuery i don't get task local variables and also there doesn't seem to be any API.List<Task> tasks = taskService.createNativeTaskQuery() .sql("SELECT * FROM AC

Re: Getting local task variable with Native Queries

trademak — Fri, 27 Dec 2013 09:30:16 GMT

That's correct, that functionality is not available on native query. Please raise a JIRA if you would like to see this being added.

Best regards,

Re: Getting local task variable with Native Queries

rohitagrawal — Wed, 15 Jan 2014 11:01:05 GMT

is there any workaround to this.
Right now just to get task custom attributes(which is strictly required in our case) we need to fetch task again using taskService one by one.

Re: Getting local task variable with Native Queries

jbarrez — Fri, 17 Jan 2014 08:47:18 GMT

No, the only workaround would be a direct mybatis query.

Re: Getting local task variable with Native Queries

jbarrez — Fri, 17 Jan 2014 13:53:40 GMT

Actually, your post triggered me to make this easier in Activiti: http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/

Re: Getting local task variable with Native Queries

swamy2156 — Tue, 24 Jun 2014 14:01:26 GMT

Jbarrez, thanks for providing simple solution like customSqlExecution feature. Its a big helping hand for me. How do I customize mapper with my own List<ResultType> instead of List<Map<String, Object>>? Could some one give an example for how to implement it.

Update: I find a way for this.
public class TaskResultType{

private String name;
private String id;

public final void setName(final String name) {
    this.name = name;
}

public final String getName() {
    return name;
}

public final void setId(final String id) {
    this.id = id;
}

public final String getId() {
    return id;
}
}
and the usage of return type as follows:

CustomSqlExecution<MyTestMapper, List<TaskResultType>> customSqlExecution =
        new AbstractCustomSqlExecution<MyTestMapper, List<TaskResultType>>(MyTestMapper.class) {

          public List<TaskResultType> execute(final MyTestMapper customMapper) {
            return customMapper.selectTasks();
          }

        };

    List<TaskResultType> results = managementService.executeCustomSql(customSqlExecution);

-Swamy.

Re: Getting local task variable with Native Queries

jbarrez — Fri, 04 Jul 2014 09:36:47 GMT

Indeed - thanks for posting this back!