Custom Query

Q&A
1

Good afternoon,

I would like to know how to make a custom query, to obtain records of several tables. I have read and tested with the JPQL documentation that the studio provides as a reference, I have used JOIN, but I have not managed to make it work and it generates an error when I finish. Has anyone made a query like this?

I have used some queries previously but it is really limited not being able to obtain data from several tables through a single query as we do a normal database like sql.

I would greatly appreciate your help.

Regards,

Victor

2

You’re out of luck there,

the implementation of JPQL in Bonita does not support JOINS

You need to ask Bonita to develop this capability and add it to the product

regards
Seán

3

Hi vgonzalez_3,

An option here could be to use REST API extensions to create your own queries to the BDM. Here is a HowTo on that.

Hope it helps
Mbonita

4

I understand, thank you for your response Seán.

Regards.