ianhomer / bugzillareports

This repository is deprecated - please use https://github.com/jnwatts/BugzillaReports
Apache License 2.0
0 stars 0 forks source link

specified sort field not found, generates warning (if same as default?) #37

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
When running this (with or without the debug=1) :
{{#bugzilla:
  |version=unspecified
  |resolution !(closed)
  |headers=hide
  |format=table
  |sort=bug_id
  |order=desc
  |debug=1
}}

I get a screen full of "Notice: Undefined index: bug_id in (blah, blah 
path...)\BugzillaReports\BSQLQuery.php on line 1203

After which the report displays as expected.

If I remove the 'sort' parameter, i.e.

{{#bugzilla:
  |version=unspecified
  |resolution !(closed)
  |headers=hide
  |format=table
  |order=desc
}}

... I get a nice clean report, but sorted ASC, not DESC, by bug_id
(presumably the default sort field.) 

...when using a sort field other then bug_id, I get only the expected
report, no error messages.

I pasted the SQL into MyphpAdmin, and it ran with no warnings or errors.

mickeyf

Original issue reported on code.google.com by mfeld...@vigil.com on 19 Aug 2009 at 5:59

GoogleCodeExporter commented 8 years ago

Original comment by ian.homer@gmail.com on 12 Dec 2009 at 10:00

GoogleCodeExporter commented 8 years ago
Sorry - should have got to this one sooner, if you want to sort on ID you 
should use
"sort=id"

{{#bugzilla:
  |sort=id
  |order=desc
  |debug=1
}}

Original comment by ian.homer@gmail.com on 6 Jan 2010 at 12:09