Add a query criteria to retrieve all executing jobs

[prajwolbhandari1]

User Story (Required on creation)

In one of our use cases we need to get the currently executing jobs. As far as I can tell, it's not available through the job apis. We need to add a query criteria may be as "executing" to query all jobs that are currently executing.

Functional Requirements (Required before implementation)

Add a query criteria to retrieve all executing jobs.

Technical Requirements (Required before implementation)

Add a "executing" query criteria similar to "executable" over here https://docs.camunda.org/manual/7.18/reference/rest/job/get-query/

[venetrius]

Hi @prajwolbhandari1 ,

We have understood your request and will now decide how we continue with your idea.

Cheers,

Gergely

[prajwolbhandari1]

@venetrius Is it ok if I work on it and open a PR?

I am thinking about something like this in the query for 'executing' query parameter.

select * from act_ru_job where LOCK_EXP_TIME_ is not null and suspension_state_=1 and LOCK_EXP_TIME_ > currenttime

What do you think?

[prajwolbhandari1]

@venetrius i have implemented this. PR is coming shortly.

[prajwolbhandari1]

@venetrius just opened a PR. Can you please take a look at it? #4494