Hi Moses, Is this a test database or production? In any case, please always make sure to take a backup of your database before doing any kind of SQL.
If you want to convert ALL the dataelements in your database to Tracker, then this should suffice: update dataelement set domaintype='TRACKER' Please be aware that it will convert everything. If you first want to take a look at which ones you want to convert, then do something like this: select dataelementid, name, domaintype from dataelement Knut On Tue, Feb 23, 2016 at 9:19 AM, moses mwale <[email protected]> wrote: > hello > > someone have an idea on how to convert data Elements which are created as > aggregates to tracker using sql at once.. please need your help > > > -- > developer_lusaka_systems > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Knut Staring Dept. of Informatics, University of Oslo Norway: +4791880522 Skype: knutstar http://dhis2.org
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
