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 <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
