topic Re: Column filter above a col list box in Discussions

Column filter above a col list box

shampton82 — Fri, 09 Jun 2023 16:56:32 GMT

Is there a way to get the column filter to show up above a col list box? Right now I have to use the Column Dialog window to get it which is annoying as it is not as nice to work with as a new window().

Thanks for any advice!

Steve

Re: Column filter above a col list box

txnelson — Fri, 08 Apr 2022 21:27:49 GMT

is this what you are talking about

This example comes from the scripting guide for Col List Box()

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
New Window( "Col List Box Example",
	Col List Box( all, width( 250 ), maxSelected( 1 ) ),
	fontobj = lb = Col List Box()
);

Re: Column filter above a col list box

shampton82 — Fri, 08 Apr 2022 22:19:26 GMT

Thanks for the quick reply Jim,

Close but not quite, looking for this:

Re: Column filter above a col list box

danschikore — Fri, 08 Apr 2022 23:45:26 GMT

Hi @shampton82 - the box shown above is a FilterColSelector:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/PopAgeGroup.jmp" );
New Window( "Filter Col Selector Example",
	Filter Col Selector( width( 250 ) )
);

The filter field will only show initially if there are more columns than can be shown.

Re: Column filter above a col list box

ErraticAttack — Sat, 09 Apr 2022 01:37:41 GMT

That does not work for JMP14 (the filter is hidden by default for JMP14). You can manually toggle the filter by using the display tree:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/PopAgeGroup.jmp" );
New Window( "Filter Col Selector Example",
	fcs = Filter Col Selector( width( 250 ) )
);
fcs[If Box( 1 )] << Set( 1 )

Re: Column filter above a col list box

jthi — Sat, 09 Apr 2022 06:31:38 GMT

I have been using similar method as @ErraticAttack demonstrated to get "col list box" (filter col selector) to easily get filterable column listing.

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");

nw = New Window("",
	flc = Filter Col Selector(dt, nlines(10)),
	((flc << Parent) << Xpath("//IfBox")) << set(1)
);

Filter col selector can also be used to create "lazy" filterable list to limit selections from columns, by first creating a data table with column names as the possible options

Names Default To Here(1);
dt_temp = Open("$SAMPLE_DATA/Big Class.jmp", invisible);

dt_filter = dt_temp << Split(
	output table("filter table"),
	Split By(:name),
	Split(:name),
	Remaining Columns(Drop All),
	Sort by Column Property,
	invisible
);
Close(dt_temp, no save);

nw = New Window("filterable list", << modal,
	V List Box(
		fcs = Filter Col Selector(dt_filter, nlines(10)),
		((fcs << Parent) << Xpath("//IfBox")) << set(1),
		H List Box(
			Button Box("OK", sel = fcs << Get selected),
			Button Box("Cancel")
		)
	);
	
);
Close(dt_filter, no save);
show(sel);

Re: Column filter above a col list box

shampton82 — Sat, 09 Apr 2022 16:40:40 GMT

Thanks for all the examples!