Hi all.
I am accessing a certain database using SQL from a JSL script.
To pull the data I want, I need to provide a specification.
The specification comes in the form of a list or matrix in JMP/JSL.
Please see code below.
/* Fetch Data from Data Table*/
Items_M = :Items << get as matrix();
/* Fetch Data from Database*/
A = Open Database("Server Specs", "SELECT * FROM CertainFolder a WHERE a.CertainColumn IN ('^Items_M^')");Of course, like this is not working. What is the simplest way to do this?
Thank you!
