Hi,
I would like to run a database query on a mouseover.
In my case I have many millions of images but am only interested in seeing very few of them, one at a time.
I have mocked up a case using data from Big Class & Big Class Families data sets.
Here’s the scenario:
From ’Big Class’ I plot weight versus height.
As a matter of interest I want to see what JAMES looks like.
I have a picture of him in ’Big Class Families’ so I thought that I could take a look by running a query when I mouse over JAMES’s marker on the GB Scatter Plot.
I have attempted to take advantage of the Hover Label / Paste Graphlet functionality. From the script below you can see that the query can easily be performed but unfortunately I have had to hard code "JAMES" into the query.
What I need is that the name "JAMES" would be put into a variable on mouseover and later used in the SQL. In that way I could look at the image of any person just by hovering my mouse over the point(s) of interest.
Names Default To Here( 1 );
dt = Open( "$Sample_Data/Big Class.jmp" );
Graph Builder(
Variables( X( :height ), Y( :weight ) ),
Elements( Points( X, Y, Legend( 3 ) ), Smoother( X, Y, Legend( 4 ) ) ),
SendToReport(
Dispatch(
{},
"Graph Builder",
FrameBox,
{Set Graphlet(
Picture(
dt = Open( "$Sample_Data/Big Class Families.jmp" );
//ImageFor = "JAMES";
ImQ = Query(
Table( dt, "t1" ),
"SELECT name, picture From t1 WHERE name = \!"JAMES\!" "
);
)
)}
)
)
);The final application is for the review of semiconductor wafers, where after making a wafermap based on defect locations, the query would go back to the database and pull the image for the defect(s) of interest. When the number of defects is occasionally quite large it is not practical to load all images into the datatable for reviewing purposes.
Thanks,
Philip
