Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

Sorting List of tasks

Avatar

Former Community Member

Hi, I've created a custom componet to retrieve task information, I use TaskSearchFilter to search the tasks, but how can I sort the task list?

I know there is filter.addSortDesc(String) and filter.addSortAsc(String), but I am not sure what to put if I want to sort by task id or completion date.

I tried to put addSortDesc("TaskId") or addSortDesc("Id") but it seems not working. Is there any docs/reference available for the list of attributes I can sort by?

thanks

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

There is a constants file in the taskmanager client jar. Here is a sample of how we use the filter to get tasks for a provided processinstanceid. We did the sort on pCREATION_TIME but this could easily be changed to pID to sort by task id.

TaskManagerQueryService tmqs = TaskManagerClientFactory.getQueryManager(clientFactory);

TaskSearchFilter taskSearchFilter = new TaskSearchFilter();

taskSearchFilter.addSortDesc(TaskSearchingConstants.pCREATION_TIME);

taskSearchFilter.addCondition(TaskSearchingConstants.pPROCESS_INSTANCE_ID, Operator.EQUALS, Long.valueOf(processInstanceId));

List results = tmqs.taskSearch(taskSearchFilter);

Hope this helps.

View solution in original post

1 Reply

Avatar

Correct answer by
Former Community Member

There is a constants file in the taskmanager client jar. Here is a sample of how we use the filter to get tasks for a provided processinstanceid. We did the sort on pCREATION_TIME but this could easily be changed to pID to sort by task id.

TaskManagerQueryService tmqs = TaskManagerClientFactory.getQueryManager(clientFactory);

TaskSearchFilter taskSearchFilter = new TaskSearchFilter();

taskSearchFilter.addSortDesc(TaskSearchingConstants.pCREATION_TIME);

taskSearchFilter.addCondition(TaskSearchingConstants.pPROCESS_INSTANCE_ID, Operator.EQUALS, Long.valueOf(processInstanceId));

List results = tmqs.taskSearch(taskSearchFilter);

Hope this helps.

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----