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
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
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 isoftcom.ic@gmail.com 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 : dhis2-devs@lists.launchpad.net
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