How to get data from BDM when we have integer and string, both kinds of data types

Q&A
1

I have tried this querry
SELECT e 
FROM Employee e 
WHERE e.positionemp LIKE :positionemp
AND e.department LIKE :department
AND e.location LIKE :location
AND e.segement LIKE :segement
AND e.nationality LIKE :nationality
AND e.employeelastname LIKE :employeelastname
AND e.employeefirstname LIKE :employeefirstname
AND e.employeetype LIKE :employeetype
AND e.vaccineprovider LIKE :vaccineprovider
AND e.immunitystatus LIKE :immunitystatus
AND( e.emloyeeno = employeeno OR e.employeeno IS NULL)
AND( e.iqamano = iqamano OR e.iqamano IS NULL)
ORDER BY e.persistenceId DESC

where employeeno and iqamano are Integer and all others are string
Not able to get the data from buisness model when any integer attribute is added

2

Like explained in the documentation, you need to pass the parameters to your query using the f parameter like this:

http://localhost:8080/bonita/API/bdm/businessData/com.company.model.Employee?q=query1&p=0&c=10&f=positionemp=value&f=department=value...

HTH
Romain

3

Did you miss the : before the employeeno and iqamano parameters ?

Like this

SELECT e
FROM Employee e
WHERE e.positionemp LIKE :positionemp
AND e.department LIKE :department
AND e.location LIKE :location
AND e.segement LIKE :segement
AND e.nationality LIKE :nationality
AND e.employeelastname LIKE :employeelastname
AND e.employeefirstname LIKE :employeefirstname
AND e.employeetype LIKE :employeetype
AND e.vaccineprovider LIKE :vaccineprovider
AND e.immunitystatus LIKE :immunitystatus
AND( e.emloyeeno = :employeeno OR e.employeeno IS NULL)
AND( e.iqamano = :iqamano OR e.iqamano IS NULL)
ORDER BY e.persistenceId DESC

4

I tried the same query still not working, it's giving the error as mentioned below

"exception": "class org.bonitasoft.engine.command.CommandExecutionException",

    "message": "USERNAME=walter.bates | org.bonitasoft.engine.command.SCommandExecutionException: org.bonitasoft.engine.business.data.SBusinessDataRepositoryException: parameter(s) are missing for query named query1 : employeelastname,positionemp,employeetype,nationality,iqamano,employeefirstname,location,employeeno,department,segement,vaccineprovider,immunitystatus"

5

How do you call your query ?

6

Fo this one I was checking in Postman

7

Fo this one I was checking in Postman

8

And how do you pass the parameters in the query ?

9

https://ibb.co/WD1xVvV

10

I mean, how do you pass the parameters when calling the query in postman ?

In your image:

  • employeelastname is an Integer ?
    *iqamano is a String ?
11

AHH ! That was just by mistake
In Postman I am just using GET method 
http://localhost:8080/bonita/API/bdm/businessData/com.company.model.Employee?q=query1&p=0&c=10

When I write a query SELECT e FROM Employee e and check on postman
I get whole data https://ibb.co/tq2FzJ6

12

Hello

just to simplify I added only 3 fields in the query https://ibb.co/Y3L7N5Q
in the GET API I added the prameters
http://localhost:8080/bonita/API/bdm/businessData/com.company.model.Employee?q=query2&p=0&c=10&f=department=Housing&f=nationality=Aruba&f=employeeno=123 

https://ibb.co/CKhx7Jd

and now I am able to get the data in postman but not on my UI designer form https://ibb.co/k97bvyP