Hi,
I'm new using charts in Apex, specially I'm going to use flash charts. I need to create one but I get "no data found" message. The problem is that I need to filter the sql query of the chart with an item defined in Page 0. So the query looks like this:
SELECT null LINK, cicle LABEL, count(*) VALUE
FROM TABLE
WHERE CODI = :P0_CODI
GROUP BY cicle
This results in a "no data found" message. However, the followin query changing the item to a constant value returns data:
SELECT null LINK, cicle LABEL, count(*) VALUE
FROM TABLE
WHERE CODI = 'C1'
GROUP BY cicle
In case the problem was with Page 0, I have created an item in the page where the chart is, and initialized the value in a "On load - before header" process. Still not working. I have also tried with computations, and doesnt work either.
Are there any restrictions to using items in the sql queries for charts, or what am i missing?
Any help will be appreciated, i have read posts but no messages look like mine :( Thanks.