Querying Process instances, no criteria for variable missing?

Camunda 7 Topics
1

How does one query for process instances that don’t have a particular variable set.

From what I can read here and here the api doesn’t provide such a criteria - and the semantics of (equals null) doesn’t include it. (It is annoying when a high-level query API gives you low-level problems to deal with).

I need to query for process instances where a variable has a particular value OR that were started before the particular variable existed.

So, what is the work-around? Any suggestions?

(Does this same problem exist in 8?)

2

Since the API does not have such criteria you’d have to execute a custom SQL query directly against the process DB. Its Schema is well known and documented.

3

Could you give more details about your use case?