Dears! Thank you for the answers.
I have no text on value field according to this dhis2=# select * from datavalue where value is NULL; dataelementid | periodid | sourceid | categoryoptioncomboid | value | storedby | lastupdated | comment | followup ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- (0 rows) dhis2=# select * from datavalue where trim(value) = ''; dataelementid | periodid | sourceid | categoryoptioncomboid | value | storedby | lastupdated | comment | followup ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- (0 rows) dhis2=# select * from datavalue where trim(value) ~ '[A-Za-z]'; dataelementid | periodid | sourceid | categoryoptioncomboid | value | storedby | lastupdated | comment | followup ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- (0 rows) dhis2=# select * from datavalue where trim(value) !~ '[0-9]'; dataelementid | periodid | sourceid | categoryoptioncomboid | value | storedby | lastupdated | comment | followup ---------------+----------+----------+-----------------------+-------+----------+-------------+---------+---------- (0 rows) Orvalho On Tue, May 14, 2013 at 9:30 AM, <deemo...@yahoo.com> wrote: > I think the value type for the data elements are not properly set because > if you set the value to be α number and an integer and also specify to or > not to allow zeros plus your validation rules then I don't think you would > these issues. > > The values are probably set to be text or so. > Sent from my BlackBerry(R) smartphone from Etisalat. Enjoy high speed mobile > broadband on our easyblaze and plans for BlackBerry. Visit > www.etisalat.com.ng for details. > > -----Original Message----- > From: Ocaya Stephen <stepho...@gmail.com> > Sender: "Dhis2-users" > <dhis2-users-bounces+deemoyes=yahoo....@lists.launchpad.net> > Date: Tue, 14 May 2013 10:22:45 > To: Orvalho Augusto<orvaq...@gmail.com> > Cc: dhis1-users<dhis2-us...@lists.launchpad.net>; DHIS 2 developers< > dhis2-devs@lists.launchpad.net> > Subject: Re: [Dhis2-users] Troubles running datamart > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
