How to write dynamic query in bonita studio bdm?
I have five filter fields in my application home page (dashboard -> where I am showing all the records from h2 DB) now I want to filter the records on these fields basis.
It may require 31 (2^5 -1) queries, some are already provided as default queries.
Isn't there a way to write a dynamic query in "custom queries" or somewhere to get the desired result at UI?
Things I have tried:
- e.g. In query "findByFirstName" when retrieving records on the basis of firstName, I also pass
" 'firstNameHere' AND <someOtherFieldFromSameTable> = 'something' "
this doesn't work.
But I want some **dynamic query** i.e. at runtime to build the query on the basis of some fields.
e.g. append **AND** clause with some other attribute.
P.S: can't comment for now
Did you ever find a good solution to this? I've also reached this limitation and am unsure how to move forward.