I am trying to use Listx to dynmically populate some data in Charts. I am using a module called AMCharts which uses Javascript to populate chart data. I have tried this multiple ways.

I used Action variables to run muleiple queries and then use the outout of the query in the Format section to populate the charts. What I have noticed is that only the last chart gets populated with the data and others are blank.

I used SUBQUERY clause in Format section to populate chart data in Javascript for displaying the chart. Again only the last one gets populated.

I used Action variables to store the entire Javascript for generaing the charts. This Action variables also executes the query and populates chart data. When I view it in "Debug" mode, I can see the correct values getting populated in Action variable. However when I print it out it just prints the variable name instead of the value. Am I doing something wrong?

Can you please help? I will email you the XML for this ListX.
Thanks,
Chhavi

You might try writing the text directly to the page (not as javascript) to prefect your subquery. Then you can throw the javascript tags back in.

Also, you might try writing the javascript out by hand first to see if you can get the chart working manually.

thanks,
-Eric

If I hard code the values in the JavaScript it works fine. If I have just one chart on the page, it works fine. When I have multiple charts, then only the last one gets renders. It might have something to do with the order of how things are rendered.

Thanks,
Chhavi

Here is the XML for the ListX that I am using.

I have tried a few different things and I feel that this is somehow related to JavaScript and ListX and how the two interact. I have 3 Actions, each of which execute a query. In the format section I have client side JavaScript code that takes the values from the query executed in Action and embeds it along with other stuff. When I do a view source of the code the first two sections have the query variable name (example: [complPct,qryAP], [complOnTimePct,qryAP]) embedded instead of the value of the query result, only the last one has the correct value. If I change the order of the statements in format section, the last one always works. Has anyone run into this before?
Thanks

Hi,

Do three query actions executed have a different name? If they have the same name, then you are overriding whatever is coming from the first two query actions. I tried loading your configuration on my system but it failed. Would you mind uploading it again?

Sindura
R2integrated