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?

How do you display a business variable list (containing SQL data) in the UI table widget?


I'm quite new to Bonitasoft. I'm currently using the Bonitasoft 7.4.3 Community Edition, to use as a POC to show to my manager the capabilities of Bonitasoft in terms of a BPM offering.

I'm having issues with displaying a business variable list containing data from a MS SQL table into the UI table widget. I've gone through the tutorials on the UI and have looked at all questions and answers containing the linking of external data and displaying the data in the UI. Below is what I've done.