Re: [Dhis2-devs] Period name based on startdate or enddate?

2017-02-15 Thread Raminosoa Rabemanantsoa, Tantely
Hi Jason, Yes, it is there. We get it. Thank you! Regards, Tantely. On Thu, Feb 16, 2017 at 10:39 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Tantley, > > Have a look at the "_periodstructure" resource table. The name of the > period is there. > > Regards, > Jason > > > On

Re: [Dhis2-devs] Period name based on startdate or enddate?

2017-02-15 Thread Jason Pickering
Hi Tantley, Have a look at the "_periodstructure" resource table. The name of the period is there. Regards, Jason On Thu, Feb 16, 2017 at 8:36 AM, Raminosoa Rabemanantsoa, Tantely < tramino...@mikolo.org> wrote: > DearCommunity, > > We are running SQL code to output data from the SQL View

[Dhis2-devs] Period name based on startdate or enddate?

2017-02-15 Thread Raminosoa Rabemanantsoa, Tantely
DearCommunity, We are running SQL code to output data from the SQL View module. We get the following table for an organization unit accross multiple periods containing results with *startdate* and *enddate*. We have set up the period to "*Monthly*". In order to output the Period name (i.e.