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> |* >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
