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.