Thu, 24 Sep 2026
Login

Get a list of years

Confluence User - 03 Dec, 2020

Hi,

I want to have a select box with a list of years.

I am using JDBC Binder and write the SQL statement.

select year from 
	(select 2004 as year
	union all
	select yl.year + 1 as year
	from yearlist yl
	where yl.year + 1 <= YEAR(GetDate()))
order by year desc;

It doesn't work well. Any suggestion? Thank you.


jdbc

1

Confluence User •
03 Dec, 2020 •
confluenceUser •
•
confluenceUser •

Got it to work using Bean Shell (smile)

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
SQLI ERROR
still issue multi page set read only . my load binder is using jdbc binder custom datasource
How to Update Environment Variable of Other Application in Same Environment
If you load & store in the section, what are the right steps to close the connection? load & store it into external database with JDBC Binder plugins and Custom datasource
how i can get value textfield to form grid ?
how i can call value subfrom to jdbc ?
jdbc datalist action
how to set primary key in jdbc binder
Joget DX 7 set up application to database
subform repeater JDBC issue
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print