Error while running query: operator does not exist: character varying ~~ bytea


I've been using Bonita for two years and developed some processes and reports well.

Almost all reports use custom query, some of them call query by rest API and others call them direct.

For example:

../API/extension/myreport?p={{pageNumber - 1}}&c={{numberOfItems}}{{params}}


../API/bdm/businessData/org.iut.model.table?q=findReq&p={{pageNumber - 1}}&c={{pageSize}}{{params2}}

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.