dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

How about?

UPDATE dataelement set zeroissignificant = TRUE;

On Wed, Jan 11, 2017 at 12:35 PM, Carlos Nyembwe <nyembwe@xxxxxxxxx> wrote:

> I propose you to use Import/Export extence for updating
>
> On Wed, Jan 11, 2017 at 12:30 PM, vunda limbe <vundalon@xxxxxxxxx> 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@xxxxxxxxx>:
>>
>>> 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@xxxxxxxxx>
>>> wrote:
>>>
>>>> [image: Boxbe] <https://www.boxbe.com/overview> This message is
>>>> eligible for Automatic Cleanup! (vundalon@xxxxxxxxx) Add cleanup rule
>>>> <https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Fkey%3D%252FF7hZ9%252FQMb%252F6l0G7Of3EH3FQdjH0fpFS7NE3sJ%252B5qtk%253D%26token%3DHqA3QeEYKFWi2zy8Mea1Sd7rcubShIK1%252FLz1Y7yJgTl%252BtjzgskWp7XlninnVzVBMT6ZZ%252FSNqfW3WFF5f4P3WjBZVsAopbwIVO19M0Q7w1AWL6BuSgcgpHw%252FmejMU3CrtrE1ZCTEtXmk%253D&tc_serial=28383408803&tc_rand=683302039&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001>
>>>> | More info
>>>> <http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=28383408803&tc_rand=683302039&utm_source=stf&utm_medium=email&utm_campaign=ANNO_CLEANUP_ADD&utm_content=001>
>>>>
>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>> 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 <+243%20813%20166%20381>*
>>> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | **Linkedin
>>> <http://www.linkedin.com/in/carloscnk> | Facebook
>>> <https://www.facebook.com/carloscnksys> | Twitter
>>> <https://twitter.com/Carlos_CNK> |*
>>>
>>
>>
>
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381 <+243%20813%20166%20381>*
> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | **Linkedin
> <http://www.linkedin.com/in/carloscnk> | Facebook
> <https://www.facebook.com/carloscnksys> | Twitter
> <https://twitter.com/Carlos_CNK> |*
>
> _______________________________________________
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049