Versions Compared

Old Version 5

changes.mady.by.user Arran Ubels

Saved on

compared with

New Version Current

changes.mady.by.user Arran Ubels

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Templates

...

ToDo
Get a parameter valueparam.paramName
Insert a value into the page - not recommended, see custom functions${param.paramName}
Boolean to stringparam.paramName?string("yes", "no")
Date to string

param.paramName?string("yyyy-MM-dd HH:mm:ss zzzz"}

String to date

param.paramName?date("MM/dd/yyyy")

Trim

param.paramName?trim

Capitalize the first letterparam.paramName?cap_first
Convert to uppercaseparam.paramName?upper_case
Capitalize the first letter of every wordparam.paramName?capitialize

...

ToDo
Limit, required for each data query, version: 1.0+
Code Block
Generic:
<@limit />
Mysql
<@limit sql=mysql />
Postgres
<@limit sql=postgres />
Custom where query, version: 1.0+
Code Block
 <@where>
  <@clause render=true>columnB=${method.value(param.test)}</@clause>
  <@clause render=false>columnC=${method.value(param.test)}</@clause>
  <@clause render=param.test='ParameterOutput'>columnD=${method.value(param.test)}</@clause>
 </@where>
Code Block
<@where type=AND>'and'> clause... </@where>
Code Block
<@where type=OR>'or'> clause... </@where>
Code Block
<@where type=AND>'and'>
<@where type=OR> clause... </@where>
<@where type=OR> clause... </@where>
<@where type=OR> clause... </@where>
</@where>