I propose you to use Import/Export extence for updating On Wed, Jan 11, 2017 at 12:30 PM, vunda limbe <vunda...@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 <nyem...@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 <vunda...@gmail.com> wrote: >> >>> [image: Boxbe] <https://www.boxbe.com/overview> This message is >>> eligible for Automatic Cleanup! (vunda...@gmail.com) 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@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 <+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* *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@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp