dhis2-devs team mailing list archive

[Harsh Atal <harsh.atal@xxxxxxxxx>]

Got it!

Thanks
harsh

On 1 December 2016 at 16:56, Jason Pickering <jason.p.pickering@xxxxxxxxx>
wrote:

> Hi Harsh,
>
> You can import the sql view with the metadata importer, just like any
> other metadata object.
>
> Regards,
> Jason
>
>
> On Thu, Dec 1, 2016 at 12:23 PM, Harsh Atal <harsh.atal@xxxxxxxxx> wrote:
>
>> Dear Morten
>>
>> The documentation talks about executing an existing sqlView but I want to
>> create a new one using the API. Not sure if that is possible.
>>
>> What we are attempting is that a dhis2 app when loaded first checks if
>> the sqlView exists(By name let's say). And if not then it creates a new one
>> through the API. Once created it can be used as usual..
>>
>> Could you please confirm.
>>
>> Thanks
>> harsh
>>
>>
>> On 30 November 2016 at 15:54, Harsh Atal <harsh.atal@xxxxxxxxx> wrote:
>>
>>> 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_sq
>>>> l_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
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>