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%3EData%20Table%20Box%20con%20filtro%20dati%20locale%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724078%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EBug%20o%20errore%20dell'utente%3F%3C%2FP%3E%3CP%3ESe%20creo%20una%20Data%20Table%20Box%20utilizzando%20il%20seguente%20codice%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%3Equindi%20seleziona%20manualmente%20'sesso'%20come%20filtro%2C%20la%20casella%20della%20tabella%20verr%C3%A0%20filtrata%20correttamente.%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%3ETuttavia%2C%20rimuovendo%20il%20commento%20dalle%20righe%207%20e%209%20e%20funzionando%2C%20il%20filtro%20non%20fa%20nulla%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%3E%C3%88%20previsto%20o%20mi%20sto%20perdendo%20qualcosa%3F%3C%2FP%3E%3CP%3E%5BUtilizzando%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%3EAutomazione%20e%20scripting%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%3ERi%3A%20Casella%20tabella%20dati%20con%20filtro%20dati%20locale%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724098%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ENon%20sono%20sicuro%20che%20si%20tratti%20di%20una%20funzionalit%C3%A0%20o%20di%20un%20bug%2C%20ma%20di%20solito%20invio%20messaggi%20ai%20filtri%20dopo%20averli%20creati.%20Lo%20script%20seguente%20funziona%20come%20intendi%2C%20penso.%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%3ERi%3A%20Casella%20tabella%20dati%20con%20filtro%20dati%20locale%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724438%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ELo%20considererei%20un%20bug%20e%20verr%C3%A0%20corretto%20per%20una%20futura%20versione%20di%20JMP.%20Grazie%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%20per%20la%20soluzione%20alternativa%3A%20%C3%A8%20una%20soluzione%20ragionevole%20per%20garantire%20che%20il%20filtro%20si%20connetta%20al%20Data%20Table%20Box.%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.