Workaround on custom BDM select query with join

Q&A
1

Hi All!
Could You please advice me with a solution of how to get BDM data for using on app page that will be similar as H2 respond on such code:

SELECT E.TYPE, E.MODEL, E.SERIALNUMBER, E.MANUFACTURER, A.ASSIGNDATE, A.ASSIGNCONDITION FROM ASSIGNEE A
JOIN EQUIPMENT E
ON A.GUID= E.GUID
WHERE A.ID = ‘hber@iug.uf’ AND A.ISASSIGNEDNOW = TRUE

I have two tables - equipment and assignee and need to get equipment table records that have the same guid’s wth assignee table by providing assignee id field

Probably requesting a whole equipment table and updating ‘assigned’ variable with JS would be my only option?

2

Hi @RuSique!

Have you tried using the BDM editor on Bonita for adding a custom query? You can use one of the default queries as an example, then the idea would be to simply call it from a Groovy script. Check out the documentation: Define and deploy the Business Data Model (BDM) | Bonita Documentation

Hope this helps.
Cheers!
-Thalía