dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #27797
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