Custom Query with LIKE operator works well on studio but not when deployed

Hi all,

I'm having some trouble with a custom query with LIKE operator when I deploy the BDM to portal. Here the details.

Apparently creating a custom query destroys both your project AND your studio application

Here I am, creating a custom query just like the one I've seen attached to the Quotation business object in one of Bonita Studio 7.10.0's many sample projects. My custom query is literally a copy&paste of the sample custom query, which does not generate any errors:
-Bonita Studio's custom findFromRequest query
-My custom findFromLesionado query

How to visualize only the last 10 orders in a case overview page using a Custom Query and APIs?

Hello everybody,

It may be a simple question but no matter how hard I try, I can't find a solution.

Here is the context:
Similar to the "Travel Request" tutorial, I have a case overview page but with one Table widget that allows me to see the status of my order (pending, rejected or approved). For instance:

------- ----------
Cust. | Status
------- ----------
1 | approved
------- ----------
2 | rejected
------- ----------
3 | pending
------- ----------

Error in Custom Query

Hi everyone, i am trying to create custom update bdm query. But suddenly when i started the process the error message like this "The business data 'requestCA' with the class name 'com.company.model.RequestCA', is not managed by the current version of the BDM" displayed right after i pressed the run button. I changed the query many times but the message keep appearing. These are queries that i have tried before:

Group_concat in a Custom query

I'm having a difficulty regarding creating a custom query in my development environment, I did the following query:

How to send a localdate parameter to custom query external API

Hi everyone,
I have a problem, I try to fill a dataTable with a "External API" using a custom query, but when I send the data I receive this error

` {"exception":"class org.bonitasoft.engine.exception.BonitaRuntimeException","message":"USERNAME=walter.bates| java.lang.IllegalArgumentException: unable to parse \\u0027\\u00222018-05-13T00:00:00.000Z\\u0022\\u0027 to type java.time.LocalDate"}`

the external api url is this

Custom Query

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.