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 < [email protected]> wrote: > 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. January 2017 or 201701), shoud we > consider the sartdate or enddate (from period table)? Here in this example, > we could observe the month repeating both for startdate and enddate. In our > understanding, each value for each category should be unique for each > month. Or is there another table containing already the period name that we > have to base the SQL query? > > > [image: Inline image 1] > > Thank you for your support! > > Kind Regards, > > Tantely. > > *This message and its attachments are confidential and solely for the > intended recipients. If received in error, please delete them and notify > the sender via reply e-mail immediately.* > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
