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.a...@gmail.com> 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.a...@gmail.com> wrote: > >> Thanks, will check this out and get back. >> >> On 30 November 2016 at 10:43, Morten Olav Hansen <mor...@dhis2.org> >> 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 <mor...@dhis2.org> >>> 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.a...@gmail.com> >>>> 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@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> >>> >> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp