#BDM #api #query #range

Hi everyone

I'm having a trouble making UI elements and flows enabled based on BDM association between 2 objects. To make clearer I'm attaching a simple diagram showing the association between the elements "operator", "area" and "customer".

diagram

Is it possible to execute a query from the process that would run directly on a MySql database? How can we do that ?

Can we have the result of this query displayed on our webform?

if yes, how?

Thanks for your answer :-)

Hi Team,

I am trying a use case, where in which i need to know all the Business Objects, Fields present in my Bonita studio via API.
Gone through the documentation, but it needs the businessDataName for getting the fields. but I need all the BusinessObjects and fields inside it, in one single API call.
Please let me know if there is any such possibility.

Thanks & Regards,
Naga siva Prasad.

Hello Bonita Community,

I was able to query data from H2 database using bdm api based on a specific parameter value. But, what I really want is to query data based on a range of a parameter value.

For example:
This is my api query now: ../API/bdm/businessData/ats.model.Customer?q=findByCustomerNumber&p=0&c=10&f=customerNumber=0001

What to do if I want to get the data based on customerNumber that has value >= 0001 and <= 0030? (customerNumber is string type attribute)

Thank you,
Virak