Description
Returns
The favorite as a quoted string.
Example
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
df = dt << Data Filter(
Add Filter(
Columns( :age, :sex, :height, :weight ),
Where( :sex == "F" ),
Where( :height >= 55 & :height <= 65 )
),
Mode( Select (1) )
);
Wait( 1 ); // for demonstration purposes
fav1 = df << Add Favorites( "Female Average Ht" );
Add one or more filter columns in a new OR group.
Clears all currently selected rows before setting a new selection.
Clears the currently selected rows.
Closes the data filter window.
Sets the columns to use in the data filter.
Shows the data table that the data filter window is using.
Removes all filters that are set.
Removes the specified columns from the data filter.
Sets how the specified categorical column levels are displayed in the filter.
Example
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
df = dt << Data Filter(
Add Filter( Columns( :age, :sex ), Where( :age == 12 ) )
);
txt = df << Get Script;
Show( txt );
Embeds the data filter in the specified window. See Add a Local Data Filter in the Scripting Guide for more information about local data filters.
Moves the data filter window to the specified location. x and y are measured in pixels. 0,0 is the top left of the monitor.
Example
dt = Open( "$SAMPLE_DATA/PopAgeGroupSubset.jmp" );
dist = Distribution( Automatic Recalc( 1 ), Continuous Distribution( Column( :POP ) ) );
filter = dist << Local Data Filter( Add Filter( Columns( :Region ) ) );
f = Function( {a}, Print( a ) );
rs = filter << Make Filter Change Handler( f );
Creates a new subset data table that contains the rows that are selected in the data filter.
Sets the filter conditions for each column. The Where clause is used for all the columns listed. To use different Where clauses for different columns, send the Match message separately for each column.
Sets the action, or mode, that is used when rows are selected using the data filter.
Saves the current row states for the data table, and then restores those states when the data filter is closed.
Displays or hides the column selector after completing a filter.
Creates a Where clause from the current state of the data filter and places it on the clipboard, where it can be pasted elsewhere.
Creates a Where clause from the current state of the data filter and saves it as a property to the data table.
Creates a Where clause from the current state of the data filter and appends it to the current journal. If there is no current journal, a new journal is opened and the Where clause is added to it.
Creates a row state column whose formula is the Where clause.
Creates a Where clause from the current state of the data filter and appends it to the current script window. If there is no current script window, a new script window is opened and the Where clause is added to it.
Sets whether the data filter window floats on top of its associated data table or behaves as a normal window.
Sets a condition for selecting rows.