dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #22485
Re: [Dhis2-users] Troubles running datamart
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, <deemoyes@xxxxxxxxx> 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 <stephocay@xxxxxxxxx>
> Sender: "Dhis2-users"
> <dhis2-users-bounces+deemoyes=yahoo.com@xxxxxxxxxxxxxxxxxxx>
> Date: Tue, 14 May 2013 10:22:45
> To: Orvalho Augusto<orvaquim@xxxxxxxxx>
> Cc: dhis1-users<dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 developers<
> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> Subject: Re: [Dhis2-users] Troubles running datamart
>
> _______________________________________________
> 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
>
>
Follow ups
References