← Back to team overview

dhis2-devs team mailing list archive

[Bug 1512098] Re: IN operator in trackedEntityInstances Web API endpoint not working

 

Could you please try again with latest 2.21 (should be available in
about 30-40 min)

** Changed in: dhis2
     Assignee: (unassigned) => Morten Olav Hansen (mortenoh)

** Changed in: dhis2
   Importance: Undecided => Medium

** Changed in: dhis2
       Status: New => Fix Committed

** Changed in: dhis2
       Status: Fix Committed => Confirmed

** Changed in: dhis2
    Milestone: None => 2.21

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1512098

Title:
  IN operator in trackedEntityInstances Web API endpoint not working

Status in DHIS:
  Confirmed

Bug description:
  
  IN operator in trackedEntityInstances Web API endpoint not working in tracker module

  When I used the web request below,

  
  https://domain.name/demo/api/trackedEntityInstances.json?ou=WmxhguWbumu&fields=orgUnit,trackedEntityInstance,attributes[displayName,attribute,value]&filter=VPd258dmpNi:IN:1;2

  I get this response,

  HTTP Status 500 - Request processing failed; nested exception is
  org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST
  node: ( near line 1, column 342 [select distinct tei from
  org.hisp.dhis.trackedentity.TrackedEntityInstance tei left join fetch
  tei.attributeValues where tei.organisationUnit.uid in ('WmxhguWbumu')
  and exists (from
  org.hisp.dhis.trackedentityattributevalue.TrackedEntityAttributeValue
  teav where teav.entityInstance=tei and
  teav.attribute.uid='VPd258dmpNi' and teav.valuein('1','2'))]

  And looking at the error, it seams this "...and teav.valuein( ......"
  should be  "....and teav.value in(..."

   This affects 2.21
  Build 20850

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1512098/+subscriptions


References