Get values in the list from SQL query

[#1]

Hi,

Is there way I could insert the column values in the list than jmp table?

Jackie__0-1684435041614.png

I 'm trying to write a JSL code to query data from database and I want to store the values from the SQL table into a variable list (not in the JMP table).
For example, save the WorkCenter sql table values in the list= {};
Any suggestions?

Thanks,

Jackie

[#2]

The simplest thing to do, would be to extract the column of data into a JMP data table(it can be an invisible table if desired) and then to use

ValueList = :column name << get values;

to move the column of data from the data table to a list, and then simply close the data table.

[#3]

Hi Jim, That's what I am doing rn, but the problem is it will keep generating multiple tables every time the query is run.
Thanks!

[#4]

Your JSL should be able to delete all of those data tables very quickly, so they will not create any issues for the user.

[#5]

1. Perform the query and get table as invisible/private

2. Get values from the table

3. Close the table

(4. Write a function to do all this if you repeat it many times with different queries)