Query all type of Jobs by processDefinitionKey

[remibantos]

Is your feature request related to a problem? Please describe.

I need to get all the deadletter jobs for a specific process definition key, in order to add this number to the total number of errors related to my business process.

As of today, the base job query does not allow to query any type of jobs (job, timer, deadletter) per process definition key.

Describe the solution you'd like

• Add the processDefinitionKey query criteria to the BaseJobQuery interface and implement it with a join on act_re_procdef to existing Mybatis queries such as selectDeadLetterJobByQueryCriteriaSql

Describe alternatives you've considered

I have considered implementing a custom query from my app that would hit directly flowable engine data model, but I would prefer to keep my app decoupled from this Flowable internal DB model, using the standard Flowable Java API.

Additional context

Notes:

• another feature request could handle the add of the processDefinitionKey criteria existing Jobs REST APIs
• I have started to implement this change and plan to submit a PR