Hi all.
I'm using Apex 5.1 and have a region based on D3 Collapsible Tree Chart Plugin.
The query returns this possible values. where colorvalues are the color to apply to any particular node in the tree:
select distinct colorvalue
from s24_dimension_periodo
-
RED
GREEN
ORANGE
I have set this attributes:
I changed the Color Scheme property. But I'd like to be modify the legend. The number of different color may vary. This is all done or configure by the user on the application. So I'd like to have a more flexible legend color mapping.
This is the query on which the tree gets populated:
select *
from
(select id
,parent\_id
,nb\_nodo label
**,colorvalue**
,sizevalue
,link
,infostring
,substr(link,1,1) page
,substr(link,instr(link,',') + 1,instr(link,',',-1)-3) param1
,substr(link,instr(link,',',-1) + 1) param2
,id\_registro
from s24_dimension_periodo
where id = (select id
from s24\_dimension\_periodo
where id\_registro = :p20\_id\_perspectiva)
union
select id
,parent\_id
,nb\_nodo label
**,colorvalue**
,sizevalue
,link
,infostring
,substr(link,1,1) page
,substr(link,instr(link,',') + 1,instr(link,',',-1)-3) param1
,substr(link,instr(link,',',-1) + 1) param2
,id\_registro
from s24_dimension_periodo
connect by prior id = parent_id
start with parent_id = (select id
from s24\_dimension\_periodo
where id\_registro = :p20\_id\_perspectiva))
As i said, the colorvalue are not fixed. I'd like to know where is possible to have a more dynamic legend. I have tried several configurations with no luck.
This is all i get:
On this example i don't want the color (GREEN, etc.) to appear.
Any will will be greatly appreciated!!!!!