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.

when i init a process, i need to the review1 can approve and only him can approve that step, and the second review its the same, depending on the init is the review that i have configured on a custom table.

i create a actorfilter, and on the implementation java code is where i guess i can take the id of the user and return it on a list but in this case is going to be only one.

Please help.

see answer to

https://community.bonitasoft.com/questions-and-answers/access-dbm-java-class-filter