Hi Devs!
Is it possible to access the relative period functions in postgres?
If so, does anybody know how?
Like these ones:
LAST_MONTH, LAST_BIMONTH, LAST_QUARTER, LAST_SIX_MONTH, MONTHS_THIS_YEAR, QUARTERS_THIS_YEAR,
Hi Kenneth,
no this is implemented in the application (java) layer. May I ask why you need this? Did you check out the analytics web api?
http://www.dhis2.org/doc/snapshot/en/user/html/ch28s17.html
If so, is there any features you miss?
regards,
Lars
···
On Tue, Apr 1, 2014 at 10:27 AM, Kenneth Børtveit kenneth.bortveit@gmail.com wrote:
Hi Devs!
Is it possible to access the relative period functions in postgres?
If so, does anybody know how?
Like these ones:
LAST_MONTH, LAST_BIMONTH, LAST_QUARTER, LAST_SIX_MONTH, MONTHS_THIS_YEAR, QUARTERS_THIS_YEAR,
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
We are going make an iReport from a query.
It uses data elements from the last 3 months relative to the month in question, but we’ve just figured it out.
We used the period format and cast it into date in postgres. Just substracted 3 months from this.
Thank you.
···
2014-04-01 10:31 GMT+02:00 Lars Helge Øverland larshelge@gmail.com:
Hi Kenneth,
no this is implemented in the application (java) layer. May I ask why you need this? Did you check out the analytics web api?
If so, is there any features you miss?
regards,
Lars
On Tue, Apr 1, 2014 at 10:27 AM, Kenneth Børtveit kenneth.bortveit@gmail.com wrote:
Hi Devs!
Is it possible to access the relative period functions in postgres?
If so, does anybody know how?
Like these ones:
LAST_MONTH, LAST_BIMONTH, LAST_QUARTER, LAST_SIX_MONTH, MONTHS_THIS_YEAR, QUARTERS_THIS_YEAR,
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp