#bdmquery

I have bonitasoft 7.10 and I connected it with mariadb. When I create cases I can get the values ​​from the database with the bdm. The problem is that when I upload the data to that same database from a csv then I cannot see that data in my form. It only shows the ones loaded by the platform. If anyone knows what is happening please I would appreciate your support.

Thank you

hi;

I create a form with UI designer version 7.11.1.

I move the object in the form, it creates automatically a table and two variables: mSA of business data type and mSA_selected of string type.

I want to display the last record of the variable mSA, i try to add a filter in mSA variable like this:

select * from mSA order by persistenceId DESC LIMIT 1

but it displays the first one. the same result if i emplace DESC by ASC. ?

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

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

Hello again, i have a question extremely complex.

I have created an actor filter, that have a name as input.

on the implementation, in the java code, i need to access to a query from my dbm called userreviewbyuserinit, that query extract one name of a reviewer from a table that is defined on a custom user table on my bdm.

anybody know how can i access to a bdm table query on a groovy script.

i don't know if this is going to work but i need to access to a table that is custom, it have 3 columns initiator, review1, review2.