Configure Multi Batch Chart to Grid and eliminate Xacute Query

[Former Member]

I am using the Multibatch Chart example from my training class and I would like to change it. I would like to use a grid instead of a chart. Please eliminate the Xacute query from the equation and only include SQL queries.

Thanks!!

[Former Member · Accepted solution]

Chip,

Create a new iGrid template and save it.

Create a new SQL Query template to the training database in FixedQuery mode. Under the "Fixed Query" tab, insert a sql statement like:

SELECT * FROM TABLE

WHERE BatchCOLUMN IN ([Param.1])

ORDER BY COLUMN ASC

Now in the html page, change the APPLET element's attributes from iChart to iGrid. Adjust the DisplayTemplate path to the new iGrid. In the Javascript function, which passes the selected batches from the first iGrid to the newly created iGrid, make sure to not only place a comma between the selected batches but also wrap each selected batchid in single quotes to satisfy the SQL statement above.

Save the page and test.