Skip to content

04 Parameters examples

Sometimes it's necessary to assign default values to parameters. This can be accomplished using the srssetup command, by matching columns with the corresponding variables, such as [[datefrom]].

Defaults

XML
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
<srs label="Parameters defaults">
  <def>
    <itm model="param" name="task_created_at_from" type="date">[[datefrom]]</itm>
    <itm model="param" name="task_created_at_to" type="date">[[dateto]]</itm>

    <itm model="command" name="srssetup" type="server"><![CDATA[
  select 
    convert(varchar, DATEADD(day, -360, GETDATE()), 23) datefrom, -- last year
    convert(varchar, EOMONTH(getdate()), 23) dateto --end of month
    ]]></itm>
  </def>
</srs>