How to improve search on filter?

[Jena_Sthitaprajna]

I am doing load testing on my environment, i am having more than 100k tasks, And defined task vairables. When i try to apply filter to search on task variables i have never get any response, How to improve because when i want to search something specific based on task variable it is not working as expected.

I see always loading screen. Is there any better way to search ?

[siffogh]

Hi @Jena_Sthitaprajna,

It looks like there is something wrong in the request. Can you provide a screenshot of the following in the dev tools:

• the networks tab.
• the console tab.

[Jena_Sthitaprajna]

Hello siffogh , this is my network tab and there is nothing on my console tab.

[Jena_Sthitaprajna]

FYI, @siffogh i set my variables when the task is created , Example :

@Configurable
public class TaskCreateListener implements TaskListener {
 @Override
    public void notify(DelegateTask delegateTask) {
        delegateTask.setVariable("HELLO", "hello");
}
}

I can access this variable when i define it on filter for tasklist but when i try to apply on existing tasklist then it doesn’t work .

looks like similar issue but not sure

Filter tasks based on task variable broken?

Hi all, Is there a bug in the camunda 7.5 filter logic? I’m in the front-end trying to filter a task based on a variable but no results are shown. Response is always the same {"_links":{},"_embedded":{},"count":0} task; [image] filter; [image] I’ve tried both equals and like operator [{name: “contractType”, operator: “eq”, value: “B2B”}] [{name: “contractType”, operator: “like”, value: “%B2B%”}] [{name: “contractType”, operator: “like”, value: “%2%”}] Kind regards

Am i doing something wrong ?

[Jena_Sthitaprajna]

@Jena_Sthitaprajna

HELLO

It works with process variable label. thanks

[Jena_Sthitaprajna]

I just found something interesting. After analysing this above script, i tried to find out why this query is taking longer time and found that some of the columns are not being indexed in mysql. I added index to these and it helps me a lot and drastically improved my task list loading time. Hopefully someone get help with this.

Table : ACT_RU_AUTHORIZATION
Columns:
TYPE_
USER_ID_
RESOURCE_TYPE_
PERMS_

Table : ACT_RE_PROCDEF
Column: KEY_

Table: ACT_RU_TASK
Column: SUSPENSE_STATE_