Citação de Kindrazki em 18 de dezembro de 2013, 15:45

SQL Para listar anos em um PARAMETRO (Webview)
[code]
connect $v{datasource2};
sql
Select
extract(year from current_date) - 2 as id
,extract(year from current_date) - 2 as descr
From
dummy
Union all
Select
extract(year from current_date) - 1
,extract(year from current_date) - 1
From
dummy
Union all
Select
extract(year from current_date)
,extract(year from current_date)
From
dummy
Union all
Select
extract(year from current_date) + 1
,extract(year from current_date) + 1
From
dummy
Union all
Select
extract(year from current_date) + 2
,extract(year from current_date) + 2
From
dummy
sql_var(sql_anos)
;
[/code]

[i][b]Dica: [/b]Criar uma include para esse sql!
Nome sugerido: script-sql-anos-parametro[/i]

Depois para usar, somente:
[code]
parameter ano label="Mês: " type="integer" values="sql_var(sql_anos)";
[/code]