593164_en-US

liliconcom

Nested data filter row selection

Hello,

 

I'm working on a project where I'll have data categorized in a data table and users will down select to a specific option via an interface I'm creating.

 

What I want the script below to do is:

1. In the left radio box, Choice 1, the person selects the age.
   1. In the data table all rows that are not that age are hidden and excluded in the data table.
2. In the right radio box, Choice 2, it's dynamically updated to only show options that are not hidden or excluded and will contain a list of names to choose from.
3. Once both of these options are selected, only 1 row will remain, which the row number is returned in my_row.

 

What I would like help on:

• Rows are not hidden and excluded automatically when options from Choice 1 are selected, even though show(1) and include(1) are included in the filter terms
• Radio box 2 is not dynamically updated as a result of the Choice 1
• Both of these do not "work together", Choice 2 overwrites row states of Choice 1 and can select from any row. This is probably because it's not dynamically updated(?)

References

• https://community.jmp.com/t5/Discussions/Nested-Multiple-Data-Filter-Context-Box/m-p/54915
• Scripting Index: Radio Box Display

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << Clear Row States;

New Window( "Example",
 Data Filter Context Box(
  H List Box(
   Panel Box( "Choice 1",
    dt << Data Filter(
     Add Filter(
      columns( :age ),
      Display( :age, Size( 140, 185 ), "Radio Box Display" ),
      Mode( Select( 1 ), Show( 1 ), Include( 1 ) )
   ) ) ),
   Panel Box( "Choice 2",
    H List Box(
     Data Filter Context Box(
      V List Box(
       dt << Data Filter(
        Add Filter(
         columns( :name ),
         Display( :name, Size( 160, 150 ), Radio Box Display ),
         Mode( Select( 1 ) )
) ) ) ) ) ) ) ) );

my_row = dt << Get selected rows;
show( my_row );

 

OtherScriptingWindows