dhis2-users team mailing list archive

Thread
Date

Re: SQL view question

To: "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: "Hinds, Ms. Angela (CAR)" <hindsang@xxxxxxxxxx>
Date: Thu, 25 Aug 2016 11:21:12 +0000
Accept-language: en-GB, en-US
Authentication-results: spf=none (sender IP is ) smtp.mailfrom=hindsang@xxxxxxxxxx;
Spamdiagnosticmetadata: NSPM
Spamdiagnosticoutput: 1:99
Thread-index: AdH+v8Wlr4bWRjIoT1+6ZVt5mqBXrg==
Thread-topic: [Dhis2-users] SQL view question

Hi

I have not used the SQL view before and after perusing the documentation, I am still not clear on

1.       Which name references are to be used in the SQL statement for the elements and table?  My current element names and short names used by the forms have spaces

2.       Using the web.api how do I get a list of the relevant reference names to use for the particular dataset

Regards,

Thank you.

Follow ups

Re: SQL view question
From: David Muturi, 2016-08-25
Re: SQL view question
From: Halvdan Hoem Grelland, 2016-08-25