topic Re: How to add a Filter column button in a column dialog box. in Discussions

How to add a Filter column button in a column dialog box.

Rajat — Mon, 22 Oct 2018 05:52:00 GMT

I have made a column dialog, in which I will select the 6 columns from all the columns. As number of columns are very large, so its very painful to look for the required column. So, I want to add a filter column button the Column Dialog window. How to add it? Below is my script for column dialog. Inside this window I want to add the filter column option.

Thanks.

dlg = Column Dialog(


A = ColList( "Time", Max Col( 1 ), Min Col( 1 ) ),
B = ColList( "Step", Max Col( 1 ), Min Col( 1 ) ),
c = ColList( "Tool", Max Col( 1 ), Min Col( 1 ) ),
D = ColList( "Name", Max Col( 1 ), Min Col( 1 ) ),
E = ColList( "Lot", Max Col( 1 ), Min Col( 1 ) ),
F = ColList( "Number", Max Col( 1 ), Min Col( 1 ) ),
G = ColList( "Run", Max Col( 1 ), Min Col( 1 ))
);

Re: How to add a Filter column button in a column dialog box.

txnelson — Mon, 22 Oct 2018 06:30:19 GMT

The Column Dialog() object automatically creates a column list with a filter. Below is the example taken directly from the Scripting Index

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Consumer Preferences.jmp" );
Column Dialog(
	ex y = ColList( "Y",
		Min Col( 1 ),
		Max Col( 2 ),
		Data Type( "Numeric" )
	),
	ex x = ColList( "X",
		Max Col( 1 ),
		Modeling Type(
			{"Continuous", "Multiple Response"}
		)
	),
	Line Up( 2,
		Text Box( "Alpha" ), ex = EditNumber( .05 ),
		Text Box( "Beta" ), ey = EditText( "xyz" )
	),
	HList( cb = Check Box( "check", 1 ) ),
	HList(
		combo = Combo Box( "option1", "option2" )
	),
	HList( rb = RadioButtons( "a", "b" ) )
);

Re: How to add a Filter column button in a column dialog box.

Rajat — Mon, 22 Oct 2018 06:40:29 GMT

If I run the code mentioned in the problem, it only shows the list of columns and variables that I have to select. Can it be like, it shows a search button, where I can type required column name and it will filter out the column list containing that name.

Re: How to add a Filter column button in a column dialog box.

txnelson — Mon, 22 Oct 2018 06:48:26 GMT

What version of JMP are you using? The filter was added to JMP 14.

If you have an earlier release you will have to build the filter yourself. There is code you can copy from an Addin that I uploaded to the JMP File Exchange. It is called

Runs Test (Wald-Wolfowitz Test) and JSL Implementation of JMP Platform Dialog Box

Re: How to add a Filter column button in a column dialog box.

Rajat — Mon, 22 Oct 2018 08:53:36 GMT

Thanks txnelson filter option shows in JMP14. Appreciate your help.
Do you know any command so, filter option get showed automatically in the column dialog.