mysql connector

MySQL connector and process variable to UI Select widget

Hi everyone,

I have a simple process with a mysql connector that should fetch data from a db and save it to a process variable. On the UI side, I want to display the process variable into a select widget.
I have a simple script that return a string in JSON format

How can i retrieve the user id using Groovy Script?

how i can to retrieve the user id using mysql query with groovy script into connector ,and save the result in a java.lang.long data type variable , because then i want to put this variable in a actor filter from Human Task, and assign this user to this Human Task.