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%3E%E5%B8%A6%E6%9C%89%E6%9C%AC%E5%9C%B0%E6%95%B0%E6%8D%AE%E8%BF%87%E6%BB%A4%E5%99%A8%E7%9A%84%E6%95%B0%E6%8D%AE%E8%A1%A8%E6%A1%86%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724078%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EBug%EF%BC%8C%E8%BF%98%E6%98%AF%E7%94%A8%E6%88%B7%E9%94%99%E8%AF%AF%EF%BC%9F%3C%2FP%3E%3CP%3E%E5%A6%82%E6%9E%9C%E6%88%91%E4%BD%BF%E7%94%A8%E4%BB%A5%E4%B8%8B%E4%BB%A3%E7%A0%81%E5%88%9B%E5%BB%BA%E6%95%B0%E6%8D%AE%E8%A1%A8%E6%A1%86%EF%BC%9A%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%3E%E7%84%B6%E5%90%8E%E6%89%8B%E5%8A%A8%E9%80%89%E6%8B%A9%E2%80%9C%E6%80%A7%E5%88%AB%E2%80%9D%E4%BD%9C%E4%B8%BA%E8%BF%87%E6%BB%A4%E5%99%A8%EF%BC%8C%E8%A1%A8%E6%A0%BC%E6%A1%86%E8%A2%AB%E6%AD%A3%E7%A1%AE%E8%BF%87%E6%BB%A4%E3%80%82%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%3E%E4%BD%86%E6%98%AF%EF%BC%8C%E5%8F%96%E6%B6%88%E6%B3%A8%E9%87%8A%E7%AC%AC%207%20%E8%A1%8C%E5%92%8C%E7%AC%AC%209%20%E8%A1%8C%E5%B9%B6%E8%BF%90%E8%A1%8C%EF%BC%8C%E8%BF%87%E6%BB%A4%E5%99%A8%E4%B8%8D%E4%BC%9A%E6%89%A7%E8%A1%8C%E4%BB%BB%E4%BD%95%E6%93%8D%E4%BD%9C%EF%BC%9A%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%E8%BF%99%E6%98%AF%E9%A2%84%E6%9C%9F%E7%9A%84%EF%BC%8C%E8%BF%98%E6%98%AF%E6%88%91%E9%94%99%E8%BF%87%E4%BA%86%E4%BB%80%E4%B9%88%EF%BC%9F%3C%2FP%3E%3CP%3E%5B%E4%BD%BF%E7%94%A8%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%3E%E8%87%AA%E5%8A%A8%E5%8C%96%E5%92%8C%E8%84%9A%E6%9C%AC%E7%BC%96%E5%86%99%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%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%B8%A6%E6%9C%89%E6%9C%AC%E5%9C%B0%E6%95%B0%E6%8D%AE%E8%BF%87%E6%BB%A4%E5%99%A8%E7%9A%84%E6%95%B0%E6%8D%AE%E8%A1%A8%E6%A1%86%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724098%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E4%B8%8D%E7%A1%AE%E5%AE%9A%E8%BF%99%E6%98%AF%E4%B8%80%E4%B8%AA%E5%8A%9F%E8%83%BD%E8%BF%98%E6%98%AF%E4%B8%80%E4%B8%AA%E9%94%99%E8%AF%AF%EF%BC%8C%E4%BD%86%E6%88%91%E9%80%9A%E5%B8%B8%E4%BC%9A%E5%9C%A8%E5%88%9B%E5%BB%BA%E8%BF%87%E6%BB%A4%E5%99%A8%E5%90%8E%E5%90%91%E5%AE%83%E4%BB%AC%E5%8F%91%E9%80%81%E6%B6%88%E6%81%AF%E3%80%82%E6%88%91%E8%AE%A4%E4%B8%BA%E4%B8%8B%E9%9D%A2%E7%9A%84%E8%84%9A%E6%9C%AC%E5%8F%AF%E4%BB%A5%E6%8C%89%E6%82%A8%E7%9A%84%E9%A2%84%E6%9C%9F%E5%B7%A5%E4%BD%9C%E3%80%82%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%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%B8%A6%E6%9C%89%E6%9C%AC%E5%9C%B0%E6%95%B0%E6%8D%AE%E8%BF%87%E6%BB%A4%E5%99%A8%E7%9A%84%E6%95%B0%E6%8D%AE%E8%A1%A8%E6%A1%86%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724438%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E8%AE%A4%E4%B8%BA%E8%BF%99%E6%98%AF%E4%B8%80%E4%B8%AA%E9%94%99%E8%AF%AF%EF%BC%8C%E5%B9%B6%E5%B0%86%E5%9C%A8%E6%9C%AA%E6%9D%A5%E7%9A%84%20JMP%20%E7%89%88%E6%9C%AC%E4%B8%AD%E4%BF%AE%E5%A4%8D%E3%80%82%E6%84%9F%E8%B0%A2%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%E6%8F%90%E4%BE%9B%E7%9A%84%E8%A7%A3%E5%86%B3%E6%96%B9%E6%B3%95%20-%20%E8%BF%99%E6%98%AF%E7%A1%AE%E4%BF%9D%E8%BF%87%E6%BB%A4%E5%99%A8%E8%BF%9E%E6%8E%A5%E5%88%B0%E6%95%B0%E6%8D%AE%E8%A1%A8%E6%A1%86%E7%9A%84%E5%90%88%E7%90%86%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88%E3%80%82%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.