Works nicely (I first mistakenly used organisationunitid instead of uid), except that the following part should be updated (I just removed it):
EXECUTE 'DELETE FROM programstageinstance_outboundsms WHERE programstageinstanceid IN (SELECT programstageinstanceid FROM programstageinstance WHERE organisationunitid = $1 OR programinstanceid IN (SELECT programinstanceid FROM programinstance WHERE organisationunitid = $1 OR trackedentityinstanceid IN (SELECT trackedentityinstanceid FROM trackedentityinstance WHERE organisationunitid = $1))) ' USING organisationunitid; On Tue, Dec 5, 2017 at 1:21 PM, Knut Staring <knu...@gmail.com> wrote: > Thanks! > > > On Tue, Dec 5, 2017 at 1:15 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Try this >> >> https://github.com/dhis2/dhis2-utils/blob/master/resources/ >> sql/delete_orgunittree_with_data.sql >> >> which will prune an entire branch of the orgunit tree. >> >> Regards, >> Jason >> >> >> On Tue, Dec 5, 2017 at 9:07 AM, Knut Staring <knu...@gmail.com> wrote: >> >>> Hi everyone, >>> >>> Are there some easy ways of pruning an OrgUnit tree? >>> >>> Basically, I have a number of countries with varying numbers of >>> subnational levels, but am only interested in one of the countries. I guess >>> in previous DHIS2 versions I could have done a detailed metadata export. >>> What would be a quick way to prune now? >>> >>> Knut >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Jason P. Pickering >> email: jason.p.picker...@gmail.com >> tel:+46764147049 <+46%2076%20414%2070%2049> >> > > > > -- > Knut Staring > > Department of Information, Evidence and Research > World Health Organization, Geneva, Switzerland > Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931 > <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522 > Skype: knutstar > -- Knut Staring Department of Information, Evidence and Research World Health Organization, Geneva, Switzerland Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 Skype: knutstar
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp