Groovy Java MSSQL

How to give user to jump into dashboard

I want to add one button in form , when user click on it , it will jump to its portal, how to archive it .

SQL Connector with variables in query


Could someone please explain or point me in the right direction as to solve the following.

I have a MSSQL Server 2008 connector and I would like to be able to add variables to my sql statement. As it stands I have the following query:

SELECT TOP 1 Document_Code FROM table

Which works fine but when I try to do the following through the script window: