dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Laura,
Be sure to clear the server cache if you perform and direct manipulation of
the database tables (Administration->Cache statistics and then "Clear
cache") . The recommended way of doing this would be to use the API instead
of manipulating these tables directly.
However, the "userdatavieworgunits" is not the table which controls which
orgunit a user is assigned to, but rather "usermembership".

Regards,
Jason

On Tue, Aug 25, 2015, 17:31 Laura E. Lincks <laura.lincks@xxxxxxxxxxxxxxxxx>
wrote:

> I'm trying to re-assign an Org Unit for Data Capture and Analysis to a
> user from the Postgres backend.
>
> I see data stored in the userdatavieworgunits table. I can insert a row
> into the table and see my results when selecting from the table but the
> changes don't affect what I see in the front end or the web api for the
> user. The information there does not change.
>
> Any tips on what I might be missing? Thanks.
>
> *Laura E. Lincks*
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>