Small Chart bug and question

[ermonty]

Hi

I'm delighted with the chart fonction of v3.0.0.241 and looking forward getting it in the command line (any forecast date on that one?)

Besides I noticed a small problem: the template option does not seem to save the Chart/Axis/Labels/Bottom Axis/Angle option. Whatever value I set, it always comes back to 90

Also, is there a way to display another value than x/y values on the chart?
i.e
select a,b,c from table where a=&A
a is master/detail in layout and it would be nice to be able to display it somewhere (title, legend, ..?) or alternatively to display the variable value(s) &A...

Thanks a lot
Eric

 

[Marco Kalter]

The axis seems indeed not to be stored in a template, we'll look into this.

Your other suggestions will be considered for a next release.

 

[ermonty]

Thanks.

As I'm becoming better, I noticed that the templates are stored in
C:\Documents and Settings\[user]\Application Data\PLSQL Developer\GraphTemplates and can be edited with a text editor (notepad, UE, ...)

It is then possible to also change some other values that are not saved properly, such as Title.Visible that is always false, no matter what, or the axis angle when it is 0 (other values are saved). Of course it's just a turn around that is overwrited each time you modify the template.

I'v got 2 other questions:

1- when I define an additional serie that is a function, i.e trend, everything is saved in the template BUT the serie used for the calculation. So each time you run the chart, you have to go to Series/Data Source and select again the same value. Do you happen to know if this could be stored by editing the template as mentioned above and what would be the correct syntax?

2-is there a way to get multiple series from a single request such as:

select month,product,quantity from table

month -> x axis
Quantity -> y axis
then, one serie for each product?

Regarding my other suggestion, having at least the ability to display a variable in the chart main title would be a big relief.

Also, when you release a help file on chart, I may have less questions :

Thanks for your support
Eric

 

[Marco Kalter]

We'll look into the missing template properties. We will also look into the additional serie with a function, I do not have a quick answer for you, but I'll report back.

Multiple series are currently not support directly from the query, but this should not be to difficult. It will requery some changes to the interface though.