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%20with%20local%20data%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724078%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EBug%2C%20or%20user%20error%3F%3C%2FP%3E%3CP%3EIf%20I%20create%20a%20Data%20Table%20Box%20using%20the%20following%20code%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%3Ethen%20manually%20select%20'sex'%20as%20the%20filter%2C%20the%20table%20box%20is%20filtered%20correctly.%26nbsp%3B%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%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%2FP%3E%3CP%3EHowever%2C%20uncommenting%20lines%207%20%26amp%3B%209%20and%20running%2C%20the%20filter%20doesn't%20do%20anything%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%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%2FP%3E%3CP%3EIs%20this%20expected%2C%20or%20am%20I%20missing%20anything%3F%3C%2FP%3E%3CP%3E%5BUsing%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%3EAutomation%20and%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%3ERe%3A%20Data%20Table%20Box%20with%20local%20data%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724098%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EI'm%20not%20sure%20if%20it's%20a%20feature%20or%20a%20bug%2C%20but%20I%20usually%20send%20messages%20to%20filters%20after%20I've%20created%20them.%20The%20script%20below%20works%20as%20you%20intend%2C%20I%20think.%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%3A%20Data%20Table%20Box%20with%20local%20data%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724438%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EI%20would%20consider%20this%20a%20bug%2C%20and%20it%20will%20be%20fixed%20for%20a%20future%20JMP%20release.%26nbsp%3B%20Thanks%26nbsp%3B%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%26nbsp%3Bfor%20the%20workaround%20-%20that%20is%20a%20reasonable%20solution%20to%20ensure%20that%20the%20filter%20connects%20to%20the%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.