Confluence User •

17 Oct, 2017 •

confluenceUser •

•

confluenceUser •

Hi Rosadilla

In your Selectbox SQL query in JDBC Binder, you can use the Date Hash Variable #date.M# to return the current system month and add this into your SQL WHERE clause. You can also use the #date.MONTH-x.M# syntax to perform some simple calculation.

For example, assuming you stored your months lookup records in table "app_fd_yearsetup" as follows:

c_number     c_month

8                   Aug
9                   Sep
10                 Oct

This example SQL will filter to show only Aug, Sep and Oct in your selectbox.

SELECT c_number, 
       c_month 
FROM   app_fd_yearsetup 
WHERE  (c_number = '#date.MONTH-2.M#' 
        OR c_number = '#date.MONTH-1.M#' 
        OR c_number = '#date.M#' ) 

Hope this helps.

Confluence User •

25 Oct, 2017 •

confluenceUser •

•

confluenceUser •

Hi Andrew,

Thanks!. It works..

1

CSV | Excel | XML | PDF