topic Re: Filter Col Selector usage in Discussions

Filter Col Selector usage

shampton82 — Fri, 09 Jun 2023 22:06:13 GMT

I'm trying to use a Filter Col Selector but I can't get it to return the selected value.

names default to here(1);

dt = Open( "$SAMPLE_DATA/Blood Pressure.jmp" );

nw=new window("test", <<modal, <<return result,
			v list box(var1=Filter Col Selector(dt),
			H List Box( Button Box( "OK" ), Button Box( "Cancel" ) ))
	
	
);

In this example var1 doesn't return the column name that was selected.

Thanks for any direction on how to use this!

Steve

Re: Filter Col Selector usage

txnelson — Mon, 15 Feb 2021 16:17:43 GMT

Here is one way to capture the value of the Filter Selector

names default to here(1);

dt = Open( "$SAMPLE_DATA/Blood Pressure.jmp" );

nw=new window("test", <<modal, <<return result,
			v list box(var1=Filter Col Selector(dt),
			H List Box( Button Box( "OK" ), Button Box( "Cancel" ) )),
			var1<<set script(zippy=var1<<get selected);
	);

The variable zippy contains the selected values

Re: Filter Col Selector usage

shampton82 — Mon, 15 Feb 2021 17:04:19 GMT

Thanks Jim!

I just noticed that the column list box that shows up does not default with the filter on, is there a way to have this option be turned on by the script vs using the red triangle?

Re: Filter Col Selector usage

txnelson — Mon, 15 Feb 2021 17:18:46 GMT

I don't see a message that will turn the filter on, but I did not do a real exhaustive search. Take a look in the Scripting Index under the FilterColSelector and maybe you can find such.