How to get rows with more than one condition?

[#1]

Hi,

I'm trying to get rows with more than one condition as so:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = dt << Get Rows Where( :sex == "F", :name == "ROBERT", :name != "MARK" );
Show( r );

But what I'm getting is only rows where : sex == "F",

Is there any way to get all rows that are :name == "ROBERT", and also rows that are :name != "MARK"  i.e. the :name rows where it is not "MARK"

[#2 · Accepted solution]

Hi,

Have you tried to build your condition as a logic statement (see below)?

r = dt << Get Rows Where( :sex == "F" | (:name == "ROBERT" | :name != "MARK" ));

This should return all the rows with Female, Roberts, or NOT Mark.

Best,

TS

[#3]

The relevant logical operators in JSL are & for AND, | for OR, and ! for NOT.