725382_en-US

liliconcom

How do I get a æist from an SQL query and let the user select the option from the list?Automation and ScriptingData AccessRe: How do I get a list from an SQL query and let the user select the option from the list?

Do you have SQL query as a string? In Query Builder? SQL Query result in JMP data table? Or possibly something else?

Re: How do I get a list from an SQL query and let the user select the option from the list?

It is a column name with multiple parameters.

For example, I have a column named fruits and there are apple, mango and orange.

multiple data for each fruits and would like to filter the column where the user can select if he wants to see apple, mango or orange data 

Re: How do I get a list from an SQL query and let the user select the option from the list?

You can maybe use just data filter

or build some more customized U using different options such as list box, check box, radio box...

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

nw = New Window("Example",
	H List Box(
		lb = List Box(:name << get values),
		rb = Check Box(:name << get values),
		cb = Radio  Box(:name << get values)
	)
);