query tasks without followUpdate and followUpdate =< today in one query?

[michi...@gmail.com]

I would like to query tasks without followUpdate and followUpdate =< today in one query. Is that possible or do I have to do serveral queries and join the results?
Thanks in advance,

Mike

[Sebastian Menski]

Hi Mike,

currently our SQL queries are only AND queries. So you can't use them to create an OR query like in your example.

As a workaround you could merge the result of two separate queries or use native queries to directly execute custom SQL queries (see [1]).

Cheers,
Sebastian


[1] http://docs.camunda.org/latest/guides/user-guide/#process-engine-process-engine-api-native-queries

[Bernd Rücker (camunda)]

Hi Mike.

 

As discussed in Berlin I perfectly understand that use case and therefor created an issue for it: https://app.camunda.com/jira/browse/CAM-2809.

 

If you like you can always create a Pull Request for it :-)

 

I might do that in some longer train ride before 7.2 release – then you owe me some beer and invitation for dinner ;-) But not yet promised…

 

Cheers (from Munich ;-))

Bernd

--
You received this message because you are subscribed to the Google Groups "camunda BPM users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to camunda-bpm-us...@googlegroups.com.
To post to this group, send email to camunda-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/camunda-bpm-users/79c381aa-e774-450f-90af-71789dfa4fbd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Michael Karas]

Hi Bernd,

OK I owe you ;)

Greetings from Garching b. München,

Mike

You received this message because you are subscribed to a topic in the Google Groups "camunda BPM users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/camunda-bpm-users/PCETyD3JJmQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to camunda-bpm-us...@googlegroups.com.

To post to this group, send email to camunda-...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/camunda-bpm-users/0222429d.00001b20.00000130%40ca-ruecker.

[Daniel Meyer]

Sounds reasonable.

Regards,
Daniel

[Bernd Rücker (camunda)]

Pull Request is now pending: https://app.camunda.com/jira/browse/CAM-2809?focusedCommentId=37076&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-37076

 

You are lucky I am sitting in a workshop where I have to be present  and listen– but not think or speak ;-)

To view this discussion on the web visit https://groups.google.com/d/msgid/camunda-bpm-users/CAAHDX1rkP%2BsubqK7uBX_Y62J4RgypbQYBgKb92%2BWb%3DTQY4XnYw%40mail.gmail.com.

[Michael Karas]

Hi Bernd,

I owe you - beer and vegan/vegetarian dinner ;)

THX Mike