ianhomer / bugzillareports

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

Custom fields that are multiple-selections #58

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
It seems that custom fields that are multiple-selections aren't supported. 
Support for this would be nice.

To reproduce:
1. add a custom field of type "Multiple-Selection Box" in Bugzilla.
2. attempt to use this field as a column in a report
3. observe the error message saying the field doesn't exist.

Original issue reported on code.google.com by ciaran.g...@gmail.com on 8 Sep 2010 at 3:42

GoogleCodeExporter commented 8 years ago
Sample error message:

BugzillaReports : Error running the sql : SELECT DISTINCT bugs.bug_id as id, 
alias, quickflag.flagdate as flagdate, priority, bug_severity as severity, 
bug_status as status, short_desc as summary, bug_file_loc as url, 
cf_Visibility, cf_Origin FROM `bugs`.bugs LEFT JOIN (SELECT bug_id as 
quickflagbugid, MAX(creation_date) as flagdate from `bugs`.flags where 
status='?' group by quickflagbugid) as quickflag on 
quickflag.quickflagbugid=bugs.bug_id where 1=1 and priority='P1' and 
bug_status='RESOLVED' order by bug_severity ASC; Unknown column 'cf_Origin' in 
'field list'

In this case, both cf_Visibility and cf_Origin are custom fields, the only 
difference being that the former is a single value, and the latter is a 
multiple selection. No problems with cf_Visibility, but including cf_Origin 
produces the above error.

Original comment by ciaran.g...@gmail.com on 8 Sep 2010 at 3:46