← Back to team overview

dhis2-devs team mailing list archive

Re: Can SQL Views be created through API?

 

Thanks, will check this out and get back.

On 30 November 2016 at 10:43, Morten Olav Hansen <morten@xxxxxxxxx> wrote:

> You can read more about it here
>
> https://ci.dhis2.org/docs/master/en/developer/html/webapi_sql_views.html
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Wed, Nov 30, 2016 at 12:12 PM, Morten Olav Hansen <morten@xxxxxxxxx>
> wrote:
>
>> Hi Harsh
>>
>> We have a /api/sqlViews endpoint you might want to look at? that should
>> enable you to create sql views using the web-api.
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Wed, Nov 30, 2016 at 12:09 PM, Harsh Atal <harsh.atal@xxxxxxxxx>
>> wrote:
>>
>>> Hi
>>>
>>> We have a reporting app which uses SQL View with variables. The app has
>>> to be used on multiple instances and we don't want to create the sql views
>>> manually on each instance. Intention is to make the app make its own sql
>>> view on start up.
>>> Is that possible?
>>>
>>> Regards
>>> harsh
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>

Follow ups

References