How about? UPDATE dataelement set zeroissignificant = TRUE;
On Wed, Jan 11, 2017 at 12:35 PM, Carlos Nyembwe <[email protected]> wrote: > I propose you to use Import/Export extence for updating > > On Wed, Jan 11, 2017 at 12:30 PM, vunda limbe <[email protected]> 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 <[email protected]>: >> >>> 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 <[email protected]> >>> wrote: >>> >>>> [image: Boxbe] <https://www.boxbe.com/overview> This message is >>>> eligible for Automatic Cleanup! ([email protected]) 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 : [email protected] >>>> 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
