roughcompass

<gel:script 
  xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
  xmlns:jelly="jelly:core"
  xmlns:mail="jelly:email">
  
  <!-- email vars -->
  <jelly:set var="emailFrom" value="me@myworld.com" />
  <jelly:set var="emailTo" value="you@yourworld.net" />
  <jelly:set var="emailServer" value="your.email.server.com" />

roughcompass

SELECT INVESTMENTS.ID INVESTMENT_PRID,
       INVESTMENTS.CODE INVESTMENT_ID,
       INVESTMENTS.ENTITY_CODE,
       INVESTMENTS.NAME INVESTMENT_NAME,
       INVESTMENTS.ODF_OBJECT_CODE INVESTMENT_TYPE,
       INVESTMENTS.IS_ACTIVE,
       INVESTMENTS.MANAGER_ID,
       INVESTMENTS.IS_OPEN_FOR_TE,
       PLANS.CODE PLAN_ID,
       PLANS.NAME PLAN_NAME,