hello,
i work on apex 5.1.3
with the oracle jet bar , i create 2 series with an order by , and the result don't respect it
- top chart : KO
serie 1:
select label, code, ValueF
from (
select 'A' as Label
, 'T01' as code
, 5 as ValueF
from dual
union
select 'B' as label
,'T03' as code
,3
from dual
union
select 'C' as label
, 'T02' as code
,5
from dual
)
order by code
serie 2:
select label, code, ValueH
from (
select 'A' as Label
, 'T01' as code
,3 as ValueH
from dual
union
select 'B' as label
,'T03' as code
,2
from dual
union
select 'C' as label
, 'T02' as code
,8
from dual
)
order by code
- below anychart : OK
serie 1:
select null as link ,label, ValueF
from (
select 'A' as Label
, 'T01' as code
, 5 as ValueF
from dual
union
select 'B' as label
,'T03' as code
,3
from dual
union
select 'C' as label
, 'T02' as code
,5
from dual
)
order by code
serie 2:
select null as link ,label, ValueH
from (
select 'A' as Label
, 'T01' as code
,3 as ValueH
from dual
union
select 'C' as label
,'T02' as code
,2
from dual
union
select 'B' as label
, 'T03' as code
,8
from dual
)
order by code
regards
jm