dropdown list

Drop down tutorial

I am trying to get my head around BonitaSoft and having some issue populating the drop down menu by using the below tutorial.

I have attached a doc with what I am trying to achieve and what I have done so far.

Appreciate any help.

JSON in dropdown list

Dropdown list with default value

Dropdown list with data from external DB in Bonita BPM Community

I would like to configure dropdown list widget in form that list data from external DB. As I am using Bonita BPM Community it is not possible to use connectors in forms. As I understand the only option to retrieve data in this case is to write a groovy script that will query data from DB for this widget. Is it correct? Or are there any other options?