How to select last element of a business object


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

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

Call a business data (custom) query with multiple filter

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:

access bdm query on groovy script for an actor filter

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.