← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 1272167] [NEW] Web API query fails for categories, category option combos and category options

 

Nope doesn't work:



On Fri, Jan 24, 2014 at 3:27 PM, Morten Olav Hansen <
1272167@xxxxxxxxxxxxxxxxxx> wrote:

> Can you show example from our dev server? It seemed to work fine when i
> tested
> On Jan 24, 2014 8:15 PM, "Juan Manuel Alcantara" <
> jmalcantara@xxxxxxxxxxxxx>
> wrote:
>
> > Hi Lars
> > This problem is present in the following versions:
> >
> >  2.13 build: 12951 date: 2014-01-24 05:53
> >  2.14 build: 13717 date: 2014-01-17 14:20
> >  2.15 build: 13768 date: 2014-01-18 00:20
> >
> > Best regards,
> > JM
> >
> >
> > El 24/01/2014, a las 01:50, Lars Helge Øverland <larshelge@xxxxxxxxx>
> > escribió:
> >
> > > Hi, what dhis version/build?
> > > On Jan 24, 2014 7:30 AM, "Juan Manuel Alcantara" <
> > jmalcantara@xxxxxxxxxxxxx>
> > > wrote:
> > >
> > >> Public bug reported:
> > >>
> > >> The query returns the following information:
> > >>
> > >> *********
> > >> HTTP Status 500 - Request processing failed; nested exception is
> > >> org.hibernate.QueryException: could not resolve property: shortName
> of:
> > >> org.hisp.dhis.dataelement.DataElementCategory [from
> > >> org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> > like
> > >> :shortName order by c.shortName]
> > >>
> > >> type Exception report
> > >>
> > >> message Request processing failed; nested exception is
> > >> org.hibernate.QueryException: could not resolve property: shortName
> of:
> > >> org.hisp.dhis.dataelement.DataElementCategory [from
> > >> org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> > >> like :shortName order by c.shortName]
> > >>
> > >> description The server encountered an internal error that prevented it
> > >> from fulfilling this request.
> > >>
> > >> +++++++++++++++
> > >>
> > >> HTTP Status 500 - Request processing failed; nested exception is
> > >> org.hibernate.QueryException: could not resolve property: name of:
> > >> org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> > >> org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> > >> lower(name) like :name order by c.name]
> > >>
> > >> type Exception report
> > >>
> > >> message Request processing failed; nested exception is
> > >> org.hibernate.QueryException: could not resolve property: name of:
> > >> org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> > >> org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> > >> lower(name) like :name order by c.name]
> > >>
> > >> description The server encountered an internal error that prevented it
> > >> from fulfilling this request.
> > >>
> > >> ++++++++++++++++
> > >>
> > >> HTTP Status 500 - Request processing failed; nested exception is
> > >> org.hibernate.QueryException: could not resolve property: shortName
> of:
> > >> org.hisp.dhis.dataelement.DataElementCategoryOption [from
> > >> org.hisp.dhis.dataelement.DataElementCategoryOption c where
> > >> lower(shortName) like :shortName order by c.shortName]
> > >>
> > >> type Exception report
> > >>
> > >> message Request processing failed; nested exception is
> > >> org.hibernate.QueryException: could not resolve property: shortName
> of:
> > >> org.hisp.dhis.dataelement.DataElementCategoryOption [from
> > >> org.hisp.dhis.dataelement.DataElementCategoryOption c where
> > >> lower(shortName) like :shortName order by c.shortName]
> > >>
> > >> description The server encountered an internal error that prevented it
> > >> from fulfilling this request.
> > >>
> > >> ** Affects: dhis2
> > >>     Importance: Undecided
> > >>         Status: New
> > >>
> > >>
> > >> ** Tags: api query
> > >>
> > >> --
> > >> You received this bug notification because you are a member of DHIS 2
> > >> developers, which is subscribed to DHIS.
> > >> https://bugs.launchpad.net/bugs/1272167
> > >>
> > >> Title:
> > >>  Web API query fails for categories, category option combos and
> > >>  category options
> > >>
> > >> Status in DHIS 2:
> > >>  New
> > >>
> > >> Bug description:
> > >>  The query returns the following information:
> > >>
> > >>  *********
> > >>  HTTP Status 500 - Request processing failed; nested exception is
> > >> org.hibernate.QueryException: could not resolve property: shortName
> of:
> > >> org.hisp.dhis.dataelement.DataElementCategory [from
> > >> org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> > like
> > >> :shortName order by c.shortName]
> > >>
> > >>  type Exception report
> > >>
> > >>  message Request processing failed; nested exception is
> > >>  org.hibernate.QueryException: could not resolve property: shortName
> > >>  of: org.hisp.dhis.dataelement.DataElementCategory [from
> > >>  org.hisp.dhis.dataelement.DataElementCategory c where
> lower(shortName)
> > >>  like :shortName order by c.shortName]
> > >>
> > >>  description The server encountered an internal error that prevented
> it
> > >>  from fulfilling this request.
> > >>
> > >>  +++++++++++++++
> > >>
> > >>  HTTP Status 500 - Request processing failed; nested exception is
> > >>  org.hibernate.QueryException: could not resolve property: name of:
> > >>  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> > >>  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> > >>  lower(name) like :name order by c.name]
> > >>
> > >>  type Exception report
> > >>
> > >>  message Request processing failed; nested exception is
> > >>  org.hibernate.QueryException: could not resolve property: name of:
> > >>  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> > >>  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> > >>  lower(name) like :name order by c.name]
> > >>
> > >>  description The server encountered an internal error that prevented
> it
> > >>  from fulfilling this request.
> > >>
> > >>  ++++++++++++++++
> > >>
> > >>  HTTP Status 500 - Request processing failed; nested exception is
> > >>  org.hibernate.QueryException: could not resolve property: shortName
> > >>  of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
> > >>  org.hisp.dhis.dataelement.DataElementCategoryOption c where
> > >>  lower(shortName) like :shortName order by c.shortName]
> > >>
> > >>  type Exception report
> > >>
> > >>  message Request processing failed; nested exception is
> > >>  org.hibernate.QueryException: could not resolve property: shortName
> > >>  of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
> > >>  org.hisp.dhis.dataelement.DataElementCategoryOption c where
> > >>  lower(shortName) like :shortName order by c.shortName]
> > >>
> > >>  description The server encountered an internal error that prevented
> it
> > >>  from fulfilling this request.
> > >>
> > >> To manage notifications about this bug go to:
> > >> https://bugs.launchpad.net/dhis2/+bug/1272167/+subscriptions
> > >>
> > >> _______________________________________________
> > >> Mailing list: https://launchpad.net/~dhis2-devs
> > >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> > >> Unsubscribe : https://launchpad.net/~dhis2-devs
> > >> More help   : https://help.launchpad.net/ListHelp
> > >>
> > >
> > > --
> > > You received this bug notification because you are subscribed to the
> bug
> > > report.
> > > https://bugs.launchpad.net/bugs/1272167
> > >
> > > Title:
> > >  Web API query fails for categories, category option combos and
> > >  category options
> > >
> > > Status in DHIS 2:
> > >  New
> > >
> > > Bug description:
> > >  The query returns the following information:
> > >
> > >  *********
> > >  HTTP Status 500 - Request processing failed; nested exception is
> > org.hibernate.QueryException: could not resolve property: shortName of:
> > org.hisp.dhis.dataelement.DataElementCategory [from
> > org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> like
> > :shortName order by c.shortName]
> > >
> > >  type Exception report
> > >
> > >  message Request processing failed; nested exception is
> > >  org.hibernate.QueryException: could not resolve property: shortName
> > >  of: org.hisp.dhis.dataelement.DataElementCategory [from
> > >  org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> > >  like :shortName order by c.shortName]
> > >
> > >  description The server encountered an internal error that prevented it
> > >  from fulfilling this request.
> > >
> > >  +++++++++++++++
> > >
> > >  HTTP Status 500 - Request processing failed; nested exception is
> > >  org.hibernate.QueryException: could not resolve property: name of:
> > >  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> > >  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> > >  lower(name) like :name order by c.name]
> > >
> > >  type Exception report
> > >
> > >  message Request processing failed; nested exception is
> > >  org.hibernate.QueryException: could not resolve property: name of:
> > >  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> > >  org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> > >  lower(name) like :name order by c.name]
> > >
> > >  description The server encountered an internal error that prevented it
> > >  from fulfilling this request.
> > >
> > >  ++++++++++++++++
> > >
> > >  HTTP Status 500 - Request processing failed; nested exception is
> > >  org.hibernate.QueryException: could not resolve property: shortName
> > >  of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
> > >  org.hisp.dhis.dataelement.DataElementCategoryOption c where
> > >  lower(shortName) like :shortName order by c.shortName]
> > >
> > >  type Exception report
> > >
> > >  message Request processing failed; nested exception is
> > >  org.hibernate.QueryException: could not resolve property: shortName
> > >  of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
> > >  org.hisp.dhis.dataelement.DataElementCategoryOption c where
> > >  lower(shortName) like :shortName order by c.shortName]
> > >
> > >  description The server encountered an internal error that prevented it
> > >  from fulfilling this request.
> > >
> > > To manage notifications about this bug go to:
> > > https://bugs.launchpad.net/dhis2/+bug/1272167/+subscriptions
> >
> > --
> > You received this bug notification because you are subscribed to DHIS.
> > https://bugs.launchpad.net/bugs/1272167
> >
> > Title:
> >   Web API query fails for categories, category option combos and
> >   category options
> >
> > Status in DHIS 2:
> >   New
> >
> > Bug description:
> >   The query returns the following information:
> >
> >   *********
> >   HTTP Status 500 - Request processing failed; nested exception is
> > org.hibernate.QueryException: could not resolve property: shortName of:
> > org.hisp.dhis.dataelement.DataElementCategory [from
> > org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> like
> > :shortName order by c.shortName]
> >
> >   type Exception report
> >
> >   message Request processing failed; nested exception is
> >   org.hibernate.QueryException: could not resolve property: shortName
> >   of: org.hisp.dhis.dataelement.DataElementCategory [from
> >   org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
> >   like :shortName order by c.shortName]
> >
> >   description The server encountered an internal error that prevented it
> >   from fulfilling this request.
> >
> >   +++++++++++++++
> >
> >   HTTP Status 500 - Request processing failed; nested exception is
> >   org.hibernate.QueryException: could not resolve property: name of:
> >   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> >   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> >   lower(name) like :name order by c.name]
> >
> >   type Exception report
> >
> >   message Request processing failed; nested exception is
> >   org.hibernate.QueryException: could not resolve property: name of:
> >   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
> >   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
> >   lower(name) like :name order by c.name]
> >
> >   description The server encountered an internal error that prevented it
> >   from fulfilling this request.
> >
> >   ++++++++++++++++
> >
> >   HTTP Status 500 - Request processing failed; nested exception is
> >   org.hibernate.QueryException: could not resolve property: shortName
> >   of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
> >   org.hisp.dhis.dataelement.DataElementCategoryOption c where
> >   lower(shortName) like :shortName order by c.shortName]
> >
> >   type Exception report
> >
> >   message Request processing failed; nested exception is
> >   org.hibernate.QueryException: could not resolve property: shortName
> >   of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
> >   org.hisp.dhis.dataelement.DataElementCategoryOption c where
> >   lower(shortName) like :shortName order by c.shortName]
> >
> >   description The server encountered an internal error that prevented it
> >   from fulfilling this request.
> >
> > To manage notifications about this bug go to:
> > https://bugs.launchpad.net/dhis2/+bug/1272167/+subscriptions
> >
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1272167
>
> Title:
>   Web API query fails for categories, category option combos and
>   category options
>
> Status in DHIS 2:
>   New
>
> Bug description:
>   The query returns the following information:
>
>   *********
>   HTTP Status 500 - Request processing failed; nested exception is
> org.hibernate.QueryException: could not resolve property: shortName of:
> org.hisp.dhis.dataelement.DataElementCategory [from
> org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName) like
> :shortName order by c.shortName]
>
>   type Exception report
>
>   message Request processing failed; nested exception is
>   org.hibernate.QueryException: could not resolve property: shortName
>   of: org.hisp.dhis.dataelement.DataElementCategory [from
>   org.hisp.dhis.dataelement.DataElementCategory c where lower(shortName)
>   like :shortName order by c.shortName]
>
>   description The server encountered an internal error that prevented it
>   from fulfilling this request.
>
>   +++++++++++++++
>
>   HTTP Status 500 - Request processing failed; nested exception is
>   org.hibernate.QueryException: could not resolve property: name of:
>   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
>   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
>   lower(name) like :name order by c.name]
>
>   type Exception report
>
>   message Request processing failed; nested exception is
>   org.hibernate.QueryException: could not resolve property: name of:
>   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo [from
>   org.hisp.dhis.dataelement.DataElementCategoryOptionCombo c where
>   lower(name) like :name order by c.name]
>
>   description The server encountered an internal error that prevented it
>   from fulfilling this request.
>
>   ++++++++++++++++
>
>   HTTP Status 500 - Request processing failed; nested exception is
>   org.hibernate.QueryException: could not resolve property: shortName
>   of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
>   org.hisp.dhis.dataelement.DataElementCategoryOption c where
>   lower(shortName) like :shortName order by c.shortName]
>
>   type Exception report
>
>   message Request processing failed; nested exception is
>   org.hibernate.QueryException: could not resolve property: shortName
>   of: org.hisp.dhis.dataelement.DataElementCategoryOption [from
>   org.hisp.dhis.dataelement.DataElementCategoryOption c where
>   lower(shortName) like :shortName order by c.shortName]
>
>   description The server encountered an internal error that prevented it
>   from fulfilling this request.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1272167/+subscriptions
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References