cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Add text boxes to use as find/filter for Table Boxes

What inspired this wish list request? 

Trying to filter down my JMP report results to see how specific columns of interest rank and it being very clunky.

 

 

What is the improvement you would like to see? 

Provide generic "Find" box which could be used with String Col Box/Number Col Box and so on. We already have right click option for Filter Where (and Select Where), but I'm looking quicker option which would add "Find" box to top of column name (or below it) so I can quickly filter the table box results.

 

Quick example (using Col Box with Text Edit Box would most likely be better idea)

View more...
Names Default To Here(1);

nw = New Window("Mountains",
	vlb = V List Box(
		tb = Table Box(
			scb = String Col Box("Mountain", {"K2", "Delphi", "Kilimanjaro", "Grand Teton"}),
			ncb = Number Col Box("Elevation (meters)", {8611, 681, 5895, 4199}),
			pcb = Plot Col Box("", {8611, 681, 5895, 4199})
		)
	)
);


// Add "filter"
vlb << Prepend(
	tb2 = Table Box(
		sceb1 = String Col Edit Box("", {""}),
		sceb2 = String Col Edit Box("", {""}),
		sceb3 = String Col Edit Box("", {""})
	)
);

tb2 << Set Cell Changed Function(function({this, col, row},
	filter_val = lowercase((col << get)[row]);
	If(Is Missing(filter_val),
		tb << reset filter;
		return();
	);
	
	Eval(EvalExpr(
		tb << Filter Where(Contains(lowercase(Mountain), Expr(filter_val)));
	));
));


sceb1 << Set Width(scb << get width);
sceb2 << Set Width(ncb << get width);
sceb3 << Set Width(pcb << get width);

jthi_0-1717694269819.png

jthi_1-1717694277478.png

 

Why is this idea important? 

Makes it much quicker to filter down Table Boxes in JMP reports.