Confluence User •

14 Sep, 2020 •

confluenceUser •

•

confluenceUser •

You can use JDBC Binder in Datalist Datasource and in your SQL, use Date Calculations:

MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates.

Your "the number of days the issue has been open" is a calculation field and is a new column in your list.

Confluence User •

14 Sep, 2020 •

confluenceUser •

•

confluenceUser •

thank you Matthew. The issue is that this "end date" is dynamic, which is the day that an user is reading the list. Therefore the "days opened" is whenever an user is showing the list compared to the "report date" that is in the database table.

Is that possible?

Confluence User •

15 Sep, 2020 •

confluenceUser •

•

confluenceUser •

Use the Joget date hash variable "#date.yyyy-MM-dd#" to plugin today's date and MySQL datediff() function.

Confluence User •

15 Sep, 2020 •

confluenceUser •

1 •

confluenceUser •

I ended up using Scheduler with Database Update Tool to run daily update for this. Don't know if it is the best way but it works for now.

1

CSV | Excel | XML | PDF