dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #07516
SQL query pointers requested
-
To:
<dhis2-users@xxxxxxxxxxxxxxxxxxx>
-
From:
"Ferdie Botha" <ferdie@xxxxxxxx>
-
Date:
Thu, 18 Jun 2015 16:43:45 +0200
-
Authentication-results:
host-h.net; auth=pass (login) smtp.auth=@hisp.org
-
Thread-index:
AdCp1D1nP2oIq4rhSnybOs5jdelWzQ==
Hi all, I need someone to point me in the right direction on the SQL
backend, using DHIS2.18.
I moved 2 orgunits from 1 parentid to another using the following 2 sql
statements:
update organisationunit set parentid = '14948' where organisationunitid =
'632' ; -- re-link parentid to ls_ap_Additional Partners instead of District
Partners
update organisationunit set parentid = '14948' where organisationunitid =
'633' ; -- re-link parentid to ls_ap_Additional Partners instead of District
Partners
Now I want to merge these 2 orgunits, but no luck. I tested the merging with
2 dummy units and this worked fine. Anything I can go check/verify to look
for the cause of this?
Thanks!
..
Ferdie Botha
Follow ups