date:20170726

Re: [Dhis2-devs] [Dhis2-users] WebAPI Bugs when filtering by level and ancestor

2017-07-26 Thread Morten Olav Hansen

Hi Mamadou

Could you please report a bug to JIRA? jira.dhis2.org

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Wed, Jul 26, 2017 at 11:52 PM, Mamadou Diao Diallo <
diao_dia...@gn.jsi.com> wrote:

> Hi Devs,
>
> I'm currently using dhis2 API to develop an App, but I have some troubles
> when I filter by *level* and *ancestor* in the same time.
>
>
>
> To clarify:
>
>
>
> *Everything is ok with this one :* URL/api/25/organisationUnits.
> json?filter=level:eq:'+level+'=[id,displayName]
>
>
>
> *But by adding ancestor parameter the level is just ignored:*
>
> URL/api/25/organisationUnits.json?filter=level:eq:'+level+'
> =ancestors.id:eq:'+ancestorId+'=[id,displayName]
>
>
> I will really appreciate your help and any link for an advanced dhis2 API
> topic.
>
> Best,
>
> Diao
>
> --
> *DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 **( District
> Health Information Software )*
>
>
> *Projet de Renforcement du Système d'Information Sanitaire en Guinée*
> *Phone : 623909413 | 662256106*
> *Skype : diawwdiallo*
> www.jsi.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] WebAPI Bugs when filtering by level and ancestor

2017-07-26 Thread Mamadou Diao Diallo

Hi Devs,

I'm currently using dhis2 API to develop an App, but I have some troubles
when I filter by *level* and *ancestor* in the same time.



To clarify:



*Everything is ok with this one :*
URL/api/25/organisationUnits.json?filter=level:eq:'+level+'=[id,displayName]



*But by adding ancestor parameter the level is just ignored:*

URL/api/25/organisationUnits.json?filter=level:eq:'+level+'=ancestors.id:
eq:'+ancestorId+'=[id,displayName]


I will really appreciate your help and any link for an advanced dhis2 API
topic.

Best,

Diao

-- 
*DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 **( District
Health Information Software )*


*Projet de Renforcement du Système d'Information Sanitaire en Guinée*
*Phone : 623909413 | 662256106*
*Skype : diawwdiallo*
www.jsi.com
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] we're hiring - software engineers

2017-07-26 Thread Lars Helge Øverland

Hi all,

the DHIS 2 team is looking for new software engineers to join our team. If
you are a developer or know someone who might be interested, have a look at
our openings here:

https://www.dhis2.org/careers



regards,

Lars




-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] SQL query contains references to protected tables error

2017-07-26 Thread Jason Pickering

Hi Pooben,
I suspect  (but not sure) this has to do with a change made here

https://github.com/dhis2/dhis2-core/commit/5e1cc7c7820950f6540e8e2f1c465ac321e26045

which strips newline characters from SQL queries. This was a weakness which
was corrected.

The "Trackedentity" tables are considered to be protected, mostly because
they could contain reference to personally identifiable information.
I am not sure, but suspect that your SQL query had new line characters, and
even though it should not have worked in 2.25, it did, due to this
weakness.

Hope that helps.

Regards,
Jason


On Wed, Jul 26, 2017 at 12:51 PM, Pooben Dass  wrote:

> I'm trying to create a SQL view in dhis 2.27 but I keeping receiving this
> error SQL query contains references to protected tables?
> Any idea why as I was able to create the view in dhis 2.25 previously and
> how can i recreate it
>
> Here is my select
>
>
> SELECT
>   trackedentityattributevalue.value AS "SystemResolutionNumber",
>   trackedentityinstance.uid AS "TrackedEntityInstanceUID",
>   trackedentityinstance.trackedentityinstanceid
> FROM
>   public.trackedentityinstance,
>   public.trackedentityattribute,
>   public.trackedentityattributevalue
> WHERE
>   trackedentityattributevalue.trackedentityinstanceid =
> trackedentityinstance.trackedentityinstanceid AND
>   trackedentityattributevalue.trackedentityattributeid =
> trackedentityattribute.trackedentityattributeid and
>   trackedentityattribute.name like 'System Resolution Number';
>
> Regards
> Pooben
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> .  Please read the
> disclaimer before opening any attachment or taking any other action in
> terms of this electronic transmission.  If you cannot access the
> disclaimer, kindly send an email to disclai...@hisp.org
>  and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be bound by the
> provisions of the disclaimer.*
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] SQL query contains references to protected tables error

2017-07-26 Thread Pooben Dass

I'm trying to create a SQL view in dhis 2.27 but I keeping receiving this
error SQL query contains references to protected tables?
Any idea why as I was able to create the view in dhis 2.25 previously and
how can i recreate it

Here is my select


SELECT
  trackedentityattributevalue.value AS "SystemResolutionNumber",
  trackedentityinstance.uid AS "TrackedEntityInstanceUID",
  trackedentityinstance.trackedentityinstanceid
FROM
  public.trackedentityinstance,
  public.trackedentityattribute,
  public.trackedentityattributevalue
WHERE
  trackedentityattributevalue.trackedentityinstanceid =
trackedentityinstance.trackedentityinstanceid AND
  trackedentityattributevalue.trackedentityattributeid =
trackedentityattribute.trackedentityattributeid and
  trackedentityattribute.name like 'System Resolution Number';

Regards
Pooben

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] ISSUE with DHIS2 version 2.27

2017-07-26 Thread Knut Staring

Yes, unfortunately this app is currently only compatible with 2.25. We hope
to be able to update it to the newer versions soon.

Knut

On Wed, Jul 26, 2017 at 11:24 AM, Omer Butt  wrote:

> Aoa Sir,
>
>
>
> In DHIS 2 version 2.27 Software while using Tabular Tracker Capture (TTC)
>  App, face this issue.
>
>
>
> Image :
>
>
>
>
>
> That Issue also Occur in  your demo  link :
>
>  https://play.dhis2.org/demo/api/apps/tabular-tracker-
> capture-220/index.html
>
>
>
> Kindly Resolve it or guiding a way how to resolve it.
>
>
>
> Thnks
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] ISSUE with DHIS2 version 2.27

2017-07-26 Thread Omer Butt

Aoa Sir,

 

In DHIS 2 version 2.27 Software while using Tabular Tracker Capture (TTC)
App, face this issue.

 

Image : 

 



 

That Issue also Occur in  your demo  link :

 https://play.dhis2.org/demo/api/apps/tabular-tracker-capture-220/index.html

 

Kindly Resolve it or guiding a way how to resolve it. 

 

Thnks

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] WebAPI Bugs when filtering by level and ancestor

[Dhis2-devs] WebAPI Bugs when filtering by level and ancestor

[Dhis2-devs] we're hiring - software engineers

Re: [Dhis2-devs] SQL query contains references to protected tables error

[Dhis2-devs] SQL query contains references to protected tables error

Re: [Dhis2-devs] ISSUE with DHIS2 version 2.27

[Dhis2-devs] ISSUE with DHIS2 version 2.27

7 matches

Site Navigation

Mail list logo

Footer information