topic Re: How do I retrieve a row of data from a table in a display window that has been selected? in Discussions

How do I retrieve a row of data from a table in a display window that has been selected?

tbidwell — Fri, 27 Oct 2023 18:38:18 GMT

I have a window that has a table in it (i.e., the first 5 rows of Big Class.jmp) that I created using the script below and I'd like to know:

1) that a row of the table was selected

2) retrieve the row of data from the table in the window

After the window has been made, let's assume the user selects a row of the table as shown in the attached image.

Note: I am using JMP ver 17.1.

names default to here(1);

dt = open("$sample_data\big class.jmp", invisible);
rpt = dt << select where(row()<5) << get as report;
nw = new window("test",
	v list box(
		outline box("Big Class", rpt)
	)
);

Re: How do I retrieve a row of data from a table in a display window that has been selected?

jthi — Fri, 27 Oct 2023 18:49:57 GMT

Report from data table is Border box with Table box inside it so you can use that

Names Default To Here(1);

dt = Open("$sample_data\big class.jmp", invisible);
rpt = dt << select where(Row() < 5) << get as report;
nw = New Window("test", 
	V List Box(
		Outline Box("Big Class", 
			rpt
		)
	)
);

rpt[Table Box(1)] << Get Selected Rows;

after you know the object type you can fairly easily see from scripting index what you can do

or you could use Show Properties

Show Properties(rpt[Table Box(1)])