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%3EDatentabellenbox%20mit%20lokalem%20Datenfilter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724078%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EFehler%20oder%20Benutzerfehler%3F%3C%2FP%3E%3CP%3EWenn%20ich%20ein%20Datentabellenfeld%20mit%20dem%20folgenden%20Code%20erstelle%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%3EWenn%20Sie%20dann%20manuell%20%E2%80%9EGeschlecht%E2%80%9C%20als%20Filter%20ausw%C3%A4hlen%2C%20wird%20das%20Tabellenfeld%20korrekt%20gefiltert.%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%3EWenn%20Sie%20jedoch%20die%20Zeilen%207%20und%209%20auskommentieren%20und%20ausf%C3%BChren%2C%20f%C3%BChrt%20der%20Filter%20zu%20nichts%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%3EIst%20das%20zu%20erwarten%20oder%20%C3%BCbersehe%20ich%20etwas%3F%3C%2FP%3E%3CP%3E%5BVerwendung%20von%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%3EAutomatisierung%20und%20Skripterstellung%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%3EBetreff%3A%20Datentabellenbox%20mit%20lokalem%20Datenfilter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724098%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EIch%20bin%20mir%20nicht%20sicher%2C%20ob%20es%20sich%20um%20eine%20Funktion%20oder%20einen%20Fehler%20handelt%2C%20aber%20normalerweise%20sende%20ich%20Nachrichten%20an%20Filter%2C%20nachdem%20ich%20sie%20erstellt%20habe.%20Ich%20denke%2C%20das%20folgende%20Skript%20funktioniert%20wie%20gew%C3%BCnscht.%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%3EBetreff%3A%20Datentabellenbox%20mit%20lokalem%20Datenfilter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724438%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EIch%20w%C3%BCrde%20dies%20als%20Fehler%20betrachten%20und%20er%20wird%20in%20einer%20zuk%C3%BCnftigen%20JMP-Version%20behoben.%20Vielen%20Dank%20an%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%20f%C3%BCr%20die%20Problemumgehung%20%E2%80%93%20das%20ist%20eine%20vern%C3%BCnftige%20L%C3%B6sung%2C%20um%20sicherzustellen%2C%20dass%20der%20Filter%20eine%20Verbindung%20zur%20Datentabellenbox%20herstellt.%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.