#customquery #JPQL

Hello,

I'm having troubles with a JPQL and I don't really understand why does it do this, for bonita this Select :
SELECT p
FROM PeticionUsuario p
WHERE p.das like :das
AND p.fecha like :fecha
AND :industria like CONCAT('%',p.industria,'%')
AND :businessLine like CONCAT('%',p.businessLine,'%')
AND p.numeroSalesForce like :numeroSalesForce
AND p.estadoPeticion like :estadoPeticion
ORDER BY p.persistenceId ASC

does not return the same result as this Select:

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
------- ----------

Hi, Is it true that BDM custom query only support "SELECT" queries? i have checked and read this documentation "https://documentation.bonitasoft.com/bonita/7.9/define-and-deploy-the-bdm" it is said that "To create a custom query, use the query tab of the Expression editor to write a query script. You can use one of the default queries as an example. A custom query can be on multiple attributes.

Hello Community

I am trying to Implement a scenario . I have stored user name, emails and Password expiry date in my Database.
Now Bonita process will Search the Database and for those where the Expiry date is 15 days from current date, the Application will send an email to User notifying about the Expiry date.

Please help in implementing this.
1) Could we use a JPQL query to return a List of Dates ? But we cannot assign this output to Process variable. Nor can we assign the output to BDM Object variable.

hi
I have used the likes as follows in JPQL query

SELECT c
FROM CarProperties c
WHERE
(c.pDateTime = :pDateTime or :pDateTime is NULL)
and (c.driverName like '%'||:driverName||'%' or :driverName is NULL) 
ORDER BY c.persistenceId ASC

this work in BonitaStudioTomcat and H2 DB
But dont work in Tomcat bundle and PostgreSQL and raise Error :
org.bonitasoft.engine.commons.exceptions.SRetryableException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Hey guys,
I created a table like in the "getting started tutorial": https://www.bonitasoft.com/resources/videos/getting-started-tutorial?des... and everything works fine.

But now I want to get my table filled not with items via one filter, but with two.
So the actual code looks like this and its working:
../API/bdm/businessData/com.company.model.ManuskriptEinsenden?q=findByUserAndStatus&p=0&c=10&f=userId={{session.user_id}}&f=status=abgelehnt