Thank you. That works great.
*Walusiku J. Muyunda* *Cell: +260967006614Cell: +260971000614* *Cell: +260953063387* *"We have heaven to win and hell to shun, our lives testify better!" <http://wildvoices.blogspot.com/>* On Thu, Oct 11, 2018 at 4:11 PM Jason Pickering <jason.p.picker...@gmail.com> wrote: > Just load the script in your database and execute it with > > SELECT * FROM delete_site_with_data('tPR9B5xETb'); > > Regards, > Jason > > On Thu, Oct 11, 2018 at 4:08 PM Walusiku Muyunda <jomuw...@gmail.com> > wrote: > >> Hi Jason, >> >> Please help with syntax for this line: >> EXECUTE 'SELECT organisationunitid from organisationunit where uid = >> 'tPR9B5xETb'''' || $1 || '''' INTO organisationunitid; Is this where I >> need to specify the uid? >> >> Thanks. >> >> *Walusiku J. Muyunda* >> >> >> *Cell: +260967006614Cell: +260971000614* >> *Cell: +260953063387* >> >> *"We have heaven to win and hell to shun, our lives testify better!" >> <http://wildvoices.blogspot.com/>* >> >> >> On Thu, Oct 11, 2018 at 1:10 PM Walusiku Muyunda <jomuw...@gmail.com> >> wrote: >> >>> Thank you Jason, this will be very helpful. Am using v2.28 and hope the >>> script will run without complaints. >>> >>> Regards. >>> >>> >>> *Walusiku J. Muyunda* >>> >>> >>> *Cell: +260967006614Cell: +260971000614* >>> *Cell: +260953063387* >>> >>> *"We have heaven to win and hell to shun, our lives testify better!" >>> <http://wildvoices.blogspot.com/>* >>> >>> >>> On Thu, Oct 11, 2018 at 12:12 PM Jason Pickering < >>> jason.p.picker...@gmail.com> wrote: >>> >>>> Hi there! >>>> >>>> You can have a look here >>>> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_orgunit_with_data.sql >>>> >>>> which will delete the site and all object associated with it. You >>>> should supply the UID of the orgunit you wish to delete as a paramater to >>>> the Postgresql function. >>>> >>>> You may also need to update the script to suit the version of DHIS2 you >>>> are running. >>>> >>>> As usual, be sure to test this on a development database first! >>>> >>>> Best regards, >>>> Jason >>>> >>>> >>>> On Thu, Oct 11, 2018 at 10:49 AM Walusiku Muyunda <jomuw...@gmail.com> >>>> wrote: >>>> >>>>> Dear All, >>>>> >>>>> Is there there anyone with a script to disassociate an Orgunit from >>>>> all associated programs or data sets so I can be able to delete it from >>>>> within DHIS2? >>>>> >>>>> Thank you. >>>>> >>>>> >>>>> >>>>> *Walusiku J. Muyunda* >>>>> >>>>> >>>>> *Cell: +260967006614Cell: +260971000614* >>>>> *Cell: +260953063387* >>>>> >>>>> *"We have heaven to win and hell to shun, our lives testify better!" >>>>> <http://wildvoices.blogspot.com/>* >>>>> _______________________________________________ >>>>> 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 >>>> >>> > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 >
_______________________________________________ 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
