Re: [Dhis2-users] [Dhis2-devs] DHIS dependency scan
Yes, I have been running regular AppScans against DHIS2 and sharing the results with the core team. Greg On Oct 27, 2016 6:14 AM, "Aamer Mohammed" wrote: > Hi Team, > > We have run vulnerability checks on DHIS dependencies using the > dependency-check maven plugin. This plugin wraps the OWASP Dependency Check > utility which uses NIST’s National Vulnerability Database (NVD) to identify > the vulnerable dependencies. > Please find the report attached. Did anyone run this kind of vulnerability > scan earlier. Any comments please? > > > Thanks > Aamer. > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > ___ 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
Re: [Dhis2-users] [Dhis2-devs] SQL query for DataSets
And to tag onto Tim's message, if you know the particular OU of interest, you can all datasets associated with it via: https://play.dhis2.org/demo/api/dataSet?filter=organisationUnits.id:eq:THEOUUIDGOESHERE Greg On Tue, Feb 21, 2017 at 1:41 PM, Timothy Harding wrote: > An alternative way to do this is to use an API call to the > /organisationUnits/ and have it also return the names of the dataSets > assigned: > > https://play.dhis2.org/dev/api/organisationUnits/?fields= > name,id,dataSets[name,id]&paging=false > > Replace the "https://play.dhis2.org/dev"; with your DHIS 2 instance > > [image: Inline image 1] > > Also note that paging=false will return all the org units, depending on > how many you have, this can take a while to return to your browser. > > > > > > > *Timothy Harding* > Sr. Systems Analyst, BAO Systems > +1 202-536-1541 | thard...@baosystems.com | http://www.baosystems.com | Skype: > hardi...@gmail.com | 2900 K Street, Suite 406, Washington D.C. 20007 > > On Tue, Feb 21, 2017 at 1:31 PM, Jim Grace wrote: > >> If you want to show each pair of assigned orgUnit and dataSet, try >> something like: >> >> SELECT ou.name AS orgunit, ds.name AS dataset >> FROM dataset ds >> JOIN datasetsource dss ON dss.datasetid = ds.datasetid >> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid >> ORDER BY ou.name, ds.name; >> >> If you want only one row per orgUnit and a column that concatenates all >> assigned dataset names, try (in Postgresql): >> >> SELECT ou.name AS orgunit, string_agg(ds.name, ' | ' ORDER BY ds.name) >> AS datasets >> FROM dataset ds >> JOIN datasetsource dss ON dss.datasetid = ds.datasetid >> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid >> GROUP BY ou.name >> ORDER BY ou.name; >> >> Cheers, >> Jim >> >> >> On Tue, Feb 21, 2017 at 12:53 PM, Raminosoa Rabemanantsoa, Tantely < >> tramino...@mikolo.org> wrote: >> >>> Dear Community, >>> >>> I am trying to pull out the list of all orgUnits and the name of the >>> questionnaire assigned to each of them via SQL View. In which table should >>> I base the SQL query in order to have the list of dataSet assigned to an >>> orgUnit? >>> >>> Regards, >>> >>> Tantely. >>> >>> *This message and its attachments are confidential and solely for the >>> intended recipients. If received in error, please delete them and notify >>> the sender via reply e-mail immediately.* >>> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Jim Grace >> Core developer, DHIS 2 >> HISP US Inc. >> http://www.dhis2.org <https://www.dhis2.org/> >> >> ___ >> 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 >> >> > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Greg Wilson BAO Systems ___ 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
Re: [Dhis2-users] [Dhis2-devs] Fwd: [dhis2-issue] (DHIS2-1264) Dashboard and Programs translations - UI language list instead of DB language list
Antonia: You are correct. There are 2 different language lists in DHIS2. Example: 1: https://play.dhis2.org/demo/api/locales/db 2: https://play.dhis2.org/demo/api/locales/ui (ref https://docs.dhis2.org/master/en/developer/html/dhis2_developer_manual_full.html#webapi_locales ) /api/locales/ui lacks the languages you apparently need. Greg On Fri, Apr 14, 2017 at 8:39 AM, Antonia - Pro wrote: > Dear developers, > the issues I opened 1 month ago > https://jira.dhis2.org/browse/DHIS2-1264 > DHIS 2 Software <https://jira.dhis2.org/browse/DHIS2> / [image: Bug] > <https://jira.dhis2.org/browse/DHIS2-1264> DHIS2-1264 > <https://jira.dhis2.org/browse/DHIS2-1264> > Dashboard and Programs translations - UI language list instead of DB > language list <https://jira.dhis2.org/browse/DHIS2-1264> > > was marked as done by Viet Nguyen, but probably he didn't understood my > explanation of the problem. I added further explanations, but I don't know > if the issues marked as "*Done*" are given in consideration in order to > be resolved. > > After the upgrade from 2.22 to 2.25 I can't translate my *Programs *or > *Dashboards*. In 2.26 the problem remains. > The problem is present also on the Demo 2.26 end Dev 2.27 servers. > My problem is for the Kurdish language, but the same problem can be viewed > for the English (Botswana), English (Cambodia), ... languages on the Demo > instance. > > [image: Immagine incorporata 3][image: Immagine incorporata 2] > > Please, someone can help me and resolve this problem. > > Thanks in advance > Antonia > > > *Eng. Antonia Bezenchek* > CIO - ICT Engineer > *InformaPRO S.r.l.* via Guido Guinizelli, 98/100, Roma 00152, Italy > tel. +39 06 5758926 <+39%2006%20575%208926>, fax +39 06 62207168 > <+39%2006%206220%207168>, P.IVA IT08095781004 > www.informapro.it - *Seguici su *LinkedIn > <https://www.linkedin.com/company/informapro> > > > -- Forwarded message -- > From: Viet Nguyen (JIRA) > Date: 2017-04-14 6:54 GMT+02:00 > Subject: [dhis2-issue] (DHIS2-1264) Dashboard and Programs translations - > UI language list instead of DB language list > To: anto...@informa.pro > > > Viet Nguyen > <https://jira.dhis2.org/secure/ViewProfile.jspa?name=vietnguyen> *updated* > [image: > Bug] DHIS2-1264 <https://jira.dhis2.org/browse/DHIS2-1264> > > DHIS 2 Software <https://jira.dhis2.org/browse/DHIS2> / [image: Bug] > <https://jira.dhis2.org/browse/DHIS2-1264> DHIS2-1264 > <https://jira.dhis2.org/browse/DHIS2-1264> > Dashboard and Programs translations - UI language list instead of DB > language list <https://jira.dhis2.org/browse/DHIS2-1264> > Change By: Viet Nguyen > <https://jira.dhis2.org/secure/ViewProfile.jspa?name=vietnguyen> > Resolution: Done > Status: Open Done > [image: Add Comment] > <https://jira.dhis2.org/browse/DHIS2-1264#add-comment> Add Comment > <https://jira.dhis2.org/browse/DHIS2-1264#add-comment> > > This message was sent by Atlassian JIRA (v7.2.3#72005-sha1:73be91d) > [image: Atlassian logo] > -- Forwarded message -- > From: Viet Nguyen (JIRA) > Date: 2017-04-14 6:53 GMT+02:00 > Subject: [dhis2-issue] (DHIS2-1264) Dashboard and Programs translations - > UI language list instead of DB language list > To: anto...@informa.pro > > > Viet Nguyen > <https://jira.dhis2.org/secure/ViewProfile.jspa?name=vietnguyen> > *commented* on [image: Bug] DHIS2-1264 > <https://jira.dhis2.org/browse/DHIS2-1264> > > Re: Dashboard and Programs translations - UI language list instead of DB > language list <https://jira.dhis2.org/browse/DHIS2-1264> > > Hi, > > If your DB locale is missing on your instance, you can add it by going > through app Data Administration -> Locale -> Add new > > Regards > [image: Add Comment] > <https://jira.dhis2.org/browse/DHIS2-1264#add-comment> Add Comment > <https://jira.dhis2.org/browse/DHIS2-1264#add-comment> > > This message was sent by Atlassian JIRA (v7.2.3#72005-sha1:73be91d) > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Greg Wilson BAO Systems gwil...@baosystems.com ___ 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
