Hi Fabio,
The following gel script is sample.
It will get projects name from SRM_PROJECTS table and write them into bg-system.log.
If there is "gel:parameter" statement in gel script, the parameter will be appeared in "Custom Script Parameters" tab like as below. You will be able to pass the value to script via parameter.
I run it in PPM15.5.1 and work fine.
-------- Sample Gel script -------------
<gel:script xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:sql="jelly:sql">
<gel:parameter default="svong" var="ClarityUser"/>
<gel:parameter default="svong" secure="true" var="ClarityPassword"/>
<sql:setDataSource url="jdbc:clarity:oracle://localhost:1521;SID=niku" driver="com.ca.clarity.jdbc.oracle.OracleDriver" user="${ClarityUser}" password="${ClarityPassword}"/>
<sql:query var="result">
select name, unique_name from srm_projects
</sql:query>
<core:forEach trim="true" items="${result.rowsByIndex}" var="row">
<core:forEach var="field" items="${row}">
<gel:out>${field}</gel:out>
</core:forEach>
</core:forEach>
</gel:script>
-------------------------------------------------
Regards,
Shoichi