This content has been marked as final. Show 7 replies
Whether 10:00 value belongs to varchar type column?
if so then in chart series just add order by clause to sort it asc order
select null,label1,value1 from table1 orderby label1
Edited by: Logaa on May 24, 2012 5:58 AM
Yes...the 10:00 is varchar, actually it is generated from to_char(date,'hh24:mi'),
and I also did order by in my sql, that is why puzzle me.
Anyone has the same issue before?
I found that the problem is in the 2D stacked Chart,
I use the SQL
select link,label, value1,value2,value3 from table
order by label
for the data source,
if some of the value1 or value2 or value3 is null value, the chart will display the data not in the "label" order,
even the sql has the "order by clause".
Can this consider as a bug in Apex or anychart? Anyone know if there any workaround?
As I want to display the value in chart, so I don't want to use nvl(value1,0) in the sql as it will display "0" in the chart.
Would select ... from ... where ... is not null order by label work for you?
If that is not giving the correct result you want, it's probably best to see which XML gets generated by APEX.
If the XML is correct, than it might be an AnyChart issue. If the XML is not correct, it's the way APEX generates it.
They way to work around that, is by generating the XML yourselves for ex. by a custom procedure.
Hope that helps
Yes...if the values is not null, then the chart label order display correctly.
Is that mean it's Apex issue when it generate the data xml?
how can i override the data xml generated by Apex?