cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-724078%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EBo%C3%AEte%20de%20table%20de%20donn%C3%A9es%20avec%20filtre%20de%20donn%C3%A9es%20local%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724078%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EBug%20ou%20erreur%20utilisateur%20%3F%3C%2FP%3E%3CP%3ESi%20je%20cr%C3%A9e%20une%20bo%C3%AEte%20de%20table%20de%20donn%C3%A9es%20en%20utilisant%20le%20code%20suivant%26nbsp%3B%3A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%20)%3B%0Anw%20%3D%20New%20Window(%20%22Demo%20Data%20Table%20Box%22%2C%0A%09Data%20Filter%20Context%20Box(%0A%09%09H%20List%20Box(%0A%09%09%09dt%20%26lt%3B%26lt%3B%20Data%20Filter(%0A%09%09%09%09%2F%2FShow%20Controls(%200%20)%2C%0A%09%09%09%09Local%2C%0A%09%09%09%09%2F%2FAdd%20Filter(%20columns(%20%3Asex%20)%20)%0A%09%09%09)%2C%20%0A%09%09%09dtb%20%3D%20data%20Table%20Box(%20dt%20)%0A%09%09)%0A%09)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Epuis%20s%C3%A9lectionnez%20manuellement%20%C2%AB%26nbsp%3Bsexe%26nbsp%3B%C2%BB%20comme%20filtre%2C%20la%20zone%20de%20tableau%20est%20filtr%C3%A9e%20correctement.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22matth1_0-1707840742618.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22matth1_0-1707840742618.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22matth1_0-1707840742618.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22matth1_0-1707840742618.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22matth1_0-1707840742618.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F61090i66F8C47D122E5177%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22matth1_0-1707840742618.png%22%20alt%3D%22matth1_0-1707840742618.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ECependant%2C%20en%20d%C3%A9commentant%20les%20lignes%207%20et%209%20et%20en%20cours%20d'ex%C3%A9cution%2C%20le%20filtre%20ne%20fait%20rien%26nbsp%3B%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22matth1_1-1707840825882.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22matth1_1-1707840825882.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22matth1_1-1707840825882.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22matth1_1-1707840825882.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22matth1_1-1707840825882.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F61091i33D5A2847941B283%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22matth1_1-1707840825882.png%22%20alt%3D%22matth1_1-1707840825882.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EEst-ce%20pr%C3%A9vu%20ou%20est-ce%20que%20j'ai%20rat%C3%A9%20quelque%20chose%26nbsp%3B%3F%3C%2FP%3E%3CP%3E%5BUtilisation%20de%20JMP%2017.2%5D%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-724078%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EAutomatisation%20et%20scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724098%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%20%3A%20Bo%C3%AEte%20de%20table%20de%20donn%C3%A9es%20avec%20filtre%20de%20donn%C3%A9es%20local%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724098%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJe%20ne%20sais%20pas%20s'il%20s'agit%20d'une%20fonctionnalit%C3%A9%20ou%20d'un%20bug%2C%20mais%20j'envoie%20g%C3%A9n%C3%A9ralement%20des%20messages%20aux%20filtres%20apr%C3%A8s%20les%20avoir%20cr%C3%A9%C3%A9s.%20Le%20script%20ci-dessous%20fonctionne%20comme%20vous%20le%20souhaitez%2C%20je%20pense.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%20)%3B%0Anw%20%3D%20New%20Window(%20%22Demo%20Data%20Table%20Box%22%2C%0A%09Data%20Filter%20Context%20Box(%0A%09%09H%20List%20Box(%0A%09%09%09dtf%20%3D%20dt%20%26lt%3B%26lt%3B%20Data%20Filter(%0A%09%09%09%09%2F%2FShow%20Controls(%200%20)%2C%0A%09%09%09%09Local%2C%0A%09%09%09%09%2F%2FAdd%20Filter(%20columns(%20%3Asex%20)%20)%0A%09%09%09)%2C%20%0A%09%09%09dtb%20%3D%20data%20Table%20Box(%20dt%20)%0A%09%09)%0A%09)%0A)%3B%0Adtf%20%26lt%3B%26lt%3B%20show%20controls%20(0)%3B%0Adtf%20%26lt%3B%26lt%3B%20Add%20Filter%20(Columns%20(%3Asex))%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724438%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%20%3A%20Bo%C3%AEte%20de%20table%20de%20donn%C3%A9es%20avec%20filtre%20de%20donn%C3%A9es%20local%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724438%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJe%20consid%C3%A9rerais%20cela%20comme%20un%20bug%2C%20et%20il%20sera%20corrig%C3%A9%20pour%20une%20future%20version%20de%20JMP.%20Merci%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610%22%20target%3D%22_blank%22%3E%40Jed_Campbell%3C%2FA%3E%20pour%20la%20solution%20de%20contournement%20-%20c'est%20une%20solution%20raisonnable%20pour%20garantir%20que%20le%20filtre%20se%20connecte%20%C3%A0%20la%20bo%C3%AEte%20de%20table%20de%20donn%C3%A9es.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
matth1
Level IV

Data Table Box with local data filter

Bug, or user error?

If I create a Data Table Box using the following code:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
nw = New Window( "Demo Data Table Box",
	Data Filter Context Box(
		H List Box(
			dt << Data Filter(
				//Show Controls( 0 ),
				Local,
				//Add Filter( columns( :sex ) )
			), 
			dtb = data Table Box( dt )
		)
	)
);

then manually select 'sex' as the filter, the table box is filtered correctly. 

matth1_0-1707840742618.png

However, uncommenting lines 7 & 9 and running, the filter doesn't do anything:

matth1_1-1707840825882.png

Is this expected, or am I missing anything?

[Using JMP 17.2]

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Data Table Box with local data filter

I'm not sure if it's a feature or a bug, but I usually send messages to filters after I've created them. The script below works as you intend, I think.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
nw = New Window( "Demo Data Table Box",
	Data Filter Context Box(
		H List Box(
			dtf = dt << Data Filter(
				//Show Controls( 0 ),
				Local,
				//Add Filter( columns( :sex ) )
			), 
			dtb = data Table Box( dt )
		)
	)
);
dtf << show controls (0);
dtf << Add Filter (Columns (:sex));

View solution in original post

2 REPLIES 2

Re: Data Table Box with local data filter

I'm not sure if it's a feature or a bug, but I usually send messages to filters after I've created them. The script below works as you intend, I think.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
nw = New Window( "Demo Data Table Box",
	Data Filter Context Box(
		H List Box(
			dtf = dt << Data Filter(
				//Show Controls( 0 ),
				Local,
				//Add Filter( columns( :sex ) )
			), 
			dtb = data Table Box( dt )
		)
	)
);
dtf << show controls (0);
dtf << Add Filter (Columns (:sex));

Re: Data Table Box with local data filter

I would consider this a bug, and it will be fixed for a future JMP release.  Thanks @Jed_Campbell for the workaround - that is a reasonable solution to ensure that the filter connects to the Data Table Box.