← Back to team overview

dhis2-devs team mailing list archive

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