dhis2-users team mailing list archive

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

Hi Joao,

It depends on your exact needs, but take a look at the "datavalue" table.

Something like

DELETE FROM datavalue where sourceid = X and periodid = Y;

X should be replaced by the organisationunitid from the organisationunit
table for the orgunit you want.

Y should be replaced by the particular periodid found in the period table.

Obviously, you should make a backup of your database before attempting such
an operation.

Regards,
Jason


On Thu, Mar 26, 2015 at 5:51 AM, Joao Mazuze <Joao_Mazuze@xxxxxxxxxxxx>
wrote:

>  Hi all,
>
> Is there any script which allows us deleting for any specific orgunit on a
> given period?
>
>
>
> Best regards,
>
>
>
>
>
> _____________________________________
>
> João Gabriel Mazuze
>
> National Database Manager
>
> Projecto CHASS-SMT
>
> Abt Associates Inc.
>
> Av. Marginal, 4067
>
> Cidade de Maputo, Moçambique
>
> Fax: (+ 258)  21486767
>
> Tel:  (+ 258)  21493525/6/8
>
> Cell: (+258) 82 4236279
>
> www.chasssmt.com
>
>
>
> [image: Description: Description: Description: Description: Description:
> Description: Description: Description: Description: Logotipo CHASS-SMT]
>
> *Somos um projecto financiado  pelo PEPFAR-II, através da USAID, para
> reforçar o Sistema de Saúde das Provincias de  Sofala, Manica e Tete.
> Pretendemos melhorar a ligação e integração do HIV  com os Cuidados
> Primários de Saúde e outros a ele relacionados em coordenação com as
> Direcções Provinciais de Saúde e outros parceiros. Através do projecto
> CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da
> qualidade dos Serviços de Saúde no país.*
>
>
>
>
>
>
> ------------------------------
> This message may contain privileged and confidential information intended
> solely for the addressee. Please do not read, disseminate or copy it unless
> you are the intended recipient. If this message has been received in error,
> we kindly ask that you notify the sender immediately by return email and
> delete all copies of the message from your system.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049