topic Re: Automatically shows Show filter option in every window in Discussions

Automatically shows Show filter option in every window

Rajat — Wed, 13 Mar 2019 05:41:39 GMT

Hi Everyone,

Everytime I deal with huge data which has many number of columns. I use show filter option to look for a particular column but this show filter option I have to activate everytime and in every window. Is their a way I can activate it permanantly or if their is any Add-In available?

Thanks

Re: Automatically shows Show filter option in every window

gzmorgan0 — Wed, 13 Mar 2019 08:32:29 GMT

@Rajat, I do not fully understand your request. Do you want:

a filter for every table you open?
for every analysis?
both?
Or are you looking for one specific column in all your tables/analyses?

You can add a custom script to your menu. The script is below. Test the script before adding it to your JMP Menu. I called this menu item Open with Columns Viewer.

From the Main Menu > View > Customize > Menus and Toolbars
Click on File
Right click on Open and select Insert After the fill out the sheet and Save and OK

Below is the script. Again, Please test this before adding it to your menu.

Open();
Main Menu("Columns Viewer");
_widx = Get Window List(Type("Dialogs"));
wv = (_widx[nitems(_widx)]  << Child); // get the OwnerBox
(wv << Xpath("//IfBox"))[1] << set(1); //turn on show filter

Maybe a JMP developer has a method to turn this on for all platforms file open via a special preferences command.

Re: Automatically shows Show filter option in every window

John_Powell_JMP — Wed, 13 Mar 2019 13:03:35 GMT

If it's a specific table you use over and over again, you can add a script (like the one mentined by gzmorgan0 that runs when the table opens.

Please see:

https://community.jmp.com/t5/Discussions/How-can-we-automatically-run-a-script-when-opening-a-table/td-p/58615

"Prompting to Run a Script upon Opening a Data Table" in the Scripting Guide

Help > Books >Scripting Guide

Re: Automatically shows Show filter option in every window

Rajat — Thu, 14 Mar 2019 05:19:01 GMT

Hi @John_Powell_JMP and @gzmorgan0 ,

My requiremnt is to make the show filter option always active in all windows (wherever applicable). I want this to every table or every window I do open, not a single table.

Thanks :)

Re: Automatically shows Show filter option in every window

gzmorgan0 — Thu, 14 Mar 2019 09:12:00 GMT

My previous example showed how to create a custom open, so that a Data Filter would be crated only when you used that open.

You can have a Data Filter created for each table opening, no matter whether you open it using the File Explorer or JMP open; the method uses a subscription to the Data Table list. If you open and run the attached script, every time a table is opened, the data filter will appear. You should also set the preference: Main Menu > File > Preferences > Tables > Use a floating window for Data Filters, select it and OK.

Names Default To Here( 1 );
f1 = Function( {dtab},
	dfilt = dtab << Data Filter();
	Print( "opening" );
);
aSub = Subscribe to Data Table List( , OnOpen( f1 ) );


//To unsubscribe run the unsubscribe JSL command
//This remains in effect until you unsubscribe or log out of your JMP session
//Unsubscribe to Data Table List(asub, ALL);

I do not know how to do this for platforms. Maybe a hot key can be created, but it is easy to add it from the menu.

Re: Automatically shows Show filter option in every window

Rajat — Thu, 14 Mar 2019 10:55:57 GMT

@gzmorgan0 , Thanks for your help but this is not I want. I wanted the similar requirement I posted in my last post. Can you please help me to unsubscribe it. I couldn't unsubscribe.

@John_Powell_JMP , Do you have any solution?

Re: Automatically shows Show filter option in every window

gzmorgan0 — Thu, 14 Mar 2019 11:06:13 GMT

Save your stuff and log off. Then log back on.

I turn on a subscription for short stints.

Re: Automatically shows Show filter option in every window

John_Powell_JMP — Thu, 14 Mar 2019 13:22:47 GMT

I don't know how this can be done without us changing JMP itself, or by creating an addin that includes a custom launch script for every platform.

I would like to ask a couple of questions to better understand.

1. Are you looking to automatically add a local data filter or a global data filter? The global data filter will affect all platforms, while the local data filter will be specific to the window(platform) being launched.

2. Even if you add a filter automatically, you will still need to configure it before it is useful. For example, you would need to pick what column(s) to filter. Is that OK or would you like to be able to preconfigure the filter too?

I'm updating this reply, because I think I now know what you mean by "filter". You want to automatically add a filter to the column selector, right? This has been requested and is being worked on for JMP 15. Unfortunately, I don't think there is a way to do it in earlier versions.

Re: Automatically shows Show filter option in every window

Rajat — Fri, 15 Mar 2019 05:07:43 GMT

@John_Powell_JMP
Thanks John for your help.
Yes, I want to automatically add a filter to the column selector.

Re: Automatically shows Show filter option in every window

hlazar — Tue, 02 Jul 2019 15:36:49 GMT

I would like to add my support for this feature. When going into any column dialog option whether a fit model, analysis, graphing, table etc you have to click the red triangle and click show filter. Then click into the entry line and type what you want. This used to be on by default for a simple graphing. I know that JMP has expanded this option for other dialogs but hopefully they can just allowed to be always shown by some preference flag.

Re: Automatically shows Show filter option in every window

pnq2msp — Mon, 30 Sep 2019 22:49:55 GMT

I would like to very much add my support for this feature. It actually surprises me that this wasn't done while implementing it in the first place.

Re: Automatically shows Show filter option in every window

John_Powell_JMP — Tue, 01 Oct 2019 12:11:45 GMT

For anyone stumbling on to this discussion, the JMP Wish List item for this request is here:

https://community.jmp.com/t5/JMP-Wish-List/Have-a-preference-that-enables-column-Show-Filter-By-Default/idi-p/207500

Please add your support for this request in the JMP Wish List if you have not already done so.