Need sql query to set all data element store zerovalue

Carloscnk · 11 January 2017 11:19

Hello Vunda

I understand your request like this,

could you try this SQL request for your problem?

SELECT * FROM public.dataelement WHERE zeroissignificant = true;

This SQL is selecting all dataelement which Zero is stored

Thanks

···

On Wed, Jan 11, 2017 at 11:49 AM, vunda limbe vundalon@gmail.com wrote:

This message is eligible for Automatic Cleanup! (vundalon@gmail.com) Add cleanup rule
| More info

Hi everyone,

I have an 2.23 instance with 1234 data elements, with store zero value not active. As I have many data element to deal with, could someone help me with a query to set them all?

Thanks.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Carlos Nyembwe

I’m just a Computer Scientist

Skype*: carloscnk1***

Cell*: (+243)813166381***

ekialongo · 11 January 2017 11:30

Hi Carlos,

thank you for your comment, but I need to an update query to enable store zero value. the query you give just show me me those have active zero store value.

···

2017-01-11 12:19 GMT+01:00 Carlos Nyembwe nyembwe@gmail.com:

Hello Vunda

I understand your request like this,

could you try this SQL request for your problem?

SELECT * FROM public.dataelement WHERE zeroissignificant = true;

This SQL is selecting all dataelement which Zero is stored

Thanks

On Wed, Jan 11, 2017 at 11:49 AM, vunda limbe vundalon@gmail.com wrote:

This message is eligible for Automatic Cleanup! (vundalon@gmail.com) Add cleanup rule
| More info

Hi everyone,

I have an 2.23 instance with 1234 data elements, with store zero value not active. As I have many data element to deal with, could someone help me with a query to set them all?

Thanks.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Carlos Nyembwe

I’m just a Computer Scientist

Skype*: carloscnk1***

Cell*: (+243)813166381***

–

Carloscnk · 11 January 2017 11:35

I propose you to use Import/Export extence for updating

···

On Wed, Jan 11, 2017 at 12:30 PM, vunda limbe vundalon@gmail.com wrote:

Hi Carlos,

thank you for your comment, but I need to an update query to enable store zero value. the query you give just show me me those have active zero store value.

–

2017-01-11 12:19 GMT+01:00 Carlos Nyembwe nyembwe@gmail.com:

Hello Vunda

I understand your request like this,

could you try this SQL request for your problem?

SELECT * FROM public.dataelement WHERE zeroissignificant = true;

This SQL is selecting all dataelement which Zero is stored

Thanks

On Wed, Jan 11, 2017 at 11:49 AM, vunda limbe vundalon@gmail.com wrote:

This message is eligible for Automatic Cleanup! (vundalon@gmail.com) Add cleanup rule
| More info

Hi everyone,

I have an 2.23 instance with 1234 data elements, with store zero value not active. As I have many data element to deal with, could someone help me with a query to set them all?

Thanks.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Carlos Nyembwe

I’m just a Computer Scientist

Skype*: carloscnk1***

Cell*: (+243)813166381***

–

Carlos Nyembwe

I’m just a Computer Scientist

Skype*: carloscnk1***

Cell*: (+243)813166381***

seidhus · 11 January 2017 11:35

Sorry vunda,

I think you have to just say ‘t’ instead of true.

···

On Wed, Jan 11, 2017 at 2:30 PM, vunda limbe vundalon@gmail.com wrote:

Hi Carlos,

thank you for your comment, but I need to an update query to enable store zero value. the query you give just show me me those have active zero store value.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2017-01-11 12:19 GMT+01:00 Carlos Nyembwe nyembwe@gmail.com:

Hello Vunda

I understand your request like this,

could you try this SQL request for your problem?

SELECT * FROM public.dataelement WHERE zeroissignificant = true;

This SQL is selecting all dataelement which Zero is stored

Thanks

On Wed, Jan 11, 2017 at 11:49 AM, vunda limbe vundalon@gmail.com wrote:

This message is eligible for Automatic Cleanup! (vundalon@gmail.com) Add cleanup rule
| More info

Hi everyone,

I have an 2.23 instance with 1234 data elements, with store zero value not active. As I have many data element to deal with, could someone help me with a query to set them all?

Thanks.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Carlos Nyembwe

I’m just a Computer Scientist

Skype*: carloscnk1***

Cell*: (+243)813166381***

–

jason · 11 January 2017 11:39

How about?

UPDATE dataelement set zeroissignificant = TRUE;

···

On Wed, Jan 11, 2017 at 12:35 PM, Carlos Nyembwe nyembwe@gmail.com wrote:

I propose you to use Import/Export extence for updating

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

On Wed, Jan 11, 2017 at 12:30 PM, vunda limbe vundalon@gmail.com wrote:

Hi Carlos,

thank you for your comment, but I need to an update query to enable store zero value. the query you give just show me me those have active zero store value.

–
Carlos Nyembwe

I’m just a Computer Scientist

Skype*: carloscnk1***

Cell*: (+243)813166381***

2017-01-11 12:19 GMT+01:00 Carlos Nyembwe nyembwe@gmail.com:

Hello Vunda

I understand your request like this,

could you try this SQL request for your problem?

SELECT * FROM public.dataelement WHERE zeroissignificant = true;

This SQL is selecting all dataelement which Zero is stored

Thanks

On Wed, Jan 11, 2017 at 11:49 AM, vunda limbe vundalon@gmail.com wrote:

This message is eligible for Automatic Cleanup! (vundalon@gmail.com) Add cleanup rule
| More info

Hi everyone,

I have an 2.23 instance with 1234 data elements, with store zero value not active. As I have many data element to deal with, could someone help me with a query to set them all?

Thanks.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Carlos Nyembwe

I’m just a Computer Scientist

Skype*: carloscnk1***

Cell*: (+243)813166381***

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049