topic Re: How to get rows with more than one condition? in Discussions

How to get rows with more than one condition?

PowerOx327 — Sat, 10 Jun 2023 23:51:37 GMT

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"

Re: How to get rows with more than one condition?

Thierry_S — Mon, 25 Jul 2022 07:25:20 GMT

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,

Re: How to get rows with more than one condition?

pmroz — Mon, 25 Jul 2022 15:47:21 GMT

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