javascript array for iGrid & iCharts

[Former Member]

Is there a way to push javascript array data to IGrid and iChart display templates?

[Former Member]

What is the original source of the data? Perhaps there's a better way...

[jcgood25]

The runtime java applets only 'pull' data by executing the underlying query template, so there is no way for you to directly 'push' data from a JavaScript array into them.

An indirect way to accomplish this would be to pass the contents of your array as a comma separated list into a query parameter (Param.x) as an IN clause in a SQL Query template or through an Xacute Query to a BLS transaction, where you could process the list as desired and return the dataset to the applet. Not a very direct approach, but a possibility.

Regards,

Jeremy

[Former Member]

I am familiar with the BLS string to xml but not the IN clause you mention. Can you shed some light on this more.

[jcgood25]

What I meant was to use 'IN' with Param.x in an SQL statement, where your array would go into a comma separated list and then into a query:

http://www.w3schools.com/sql/sql_in.asp

Regards,

Jeremy