APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pie Chart sql Query

MontherzAug 15 2016 — edited Aug 22 2016

Hi Guys,

My Apex version is 5.0.4.00.12 and I'm using D3 Pie Chart Plug-in my SQL Query is :

select

null LINK,

Col1 LABEL,

COUNT(Col1) VALUE

from Table1

where :16_ListOfValue = 1

group by Col1

16_ListOfValue is a simple list of value contains the columns names in Table1 that i want to filter against but I always get no data found ... is somthing wrong in what I'm doing?

note that I did the Query with no where clause and the Pie Chart worked fine.

Please check:

https://apex.oracle.com/pls/apex/f?p=42679:1

Thank You

This post has been answered by Montherz on Aug 22 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2016

Added on Aug 15 2016

#apex-discussions

7 comments

718 views