Charts for custom field search

RT Users
1

Hello,

I’m having trouble trying to get a bar chart to show for tickets which
have a specific value for a custom field. As per the TicketSQL wiki on
bestpratical.com, I’d edited the condition in the “Advanced” area to use
CustomField.My_Custom_Fieldname = ‘My Value’ and then performed the search.

As expected, I got a list of tickets which had the given value for the
given custom field. However, when I attempted to view the bar chart for the
resultant data, giving CreatedDaily as group by condition, I get just a blank
chart. I’m using RT 3.6.4.

My custom field has an ‘_’ in it. Is that the cause? Does RT 7 have chart
support for custom fields?

Thanks and Regards,
Terence Monteiro.

DeepRoot Linux,
Ph: +91 (80) 4112 4784 / 85.

2

Hello,

I’m having trouble trying to get a bar chart to show for tickets which
have a specific value for a custom field. As per the TicketSQL wiki on
bestpratical.com, I’d edited the condition in the “Advanced” area to use
CustomField.My_Custom_Fieldname = ‘My Value’ and then performed the search.

As expected, I got a list of tickets which had the given value for the
given custom field. However, when I attempted to view the bar chart for the
resultant data, giving CreatedDaily as group by condition, I get just a blank
chart. I’m using RT 3.6.4.

My custom field has an ‘_’ in it. Is that the cause? Does RT 7 have chart
support for custom fields?

What kind of Database?

If Oracle, DBIx::SearchBuilder 1.50 fixes this.

Emmanuel Lacour ------------------------------------ Easter-eggs
44-46 rue de l’Ouest - 75014 Paris - France - M�tro Gait�
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 41 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

3

Hi Emmanuel,

Hello,

I’m having trouble trying to get a bar chart to show for tickets which
have a specific value for a custom field. As per the TicketSQL wiki on
bestpratical.com, I’d edited the condition in the “Advanced” area to use
CustomField.My_Custom_Fieldname = ‘My Value’ and then performed the search.

As expected, I got a list of tickets which had the given value for the
given custom field. However, when I attempted to view the bar chart for the
resultant data, giving CreatedDaily as group by condition, I get just a blank
chart. I’m using RT 3.6.4.

My custom field has an ‘_’ in it. Is that the cause? Does RT 7 have chart
support for custom fields?

What kind of Database?

I’m running debian etch and using mysql 5.0.41-Debian_1.

If Oracle, DBIx::SearchBuilder 1.50 fixes this.

Thanks and Regards,
Terence Monteiro.

DeepRoot Linux,
Ph: +91 (80) 4112 4784 / 85.

4

Hi Emmanuel,

I’m running debian etch and using mysql 5.0.41-Debian_1.

Ok, so it’s another problem.

Do you have the correct information in the table under the blank chart?

Emmanuel Lacour ------------------------------------ Easter-eggs
44-46 rue de l’Ouest - 75014 Paris - France - M�tro Gait�
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 41 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com