Two conditions in SELECT Expert 2

[epoh]

Hi all:

Is there a way to filter out records that meet two conditions?

SELECT EXPERT:

{Daily.UserName} <> "user" and
{Daily.Type} <> "Early"

I only want to filter out Username "user" and Type "Early" not
"user" and "Late" or
"joe" and "Early.

Thanks

 

[epoh]

Again Turkbear excellent suggestion!

Here is my functioning code:

{Daily.TimeGenerated} = currentdate-1 and
{@Filter} <> "59Late" and
{Daily.UserName} <> "user" and
{Daily.UserName} <> "user2"

 

[lbass]

In my earlier (brash!) statement, I meant that parens around simple "and" statements don't matter--they do, of course, matter in setting off if-thens that are connected by "ands" or when used with "not".

I'm not sure what epoh was looking for in terms of the late field in relation to type 59, but I'm betting that if only the "user" or "user2" that was "late" needed to be excluded, that part of the formula could have been written like:

not(
{table.user} in ["user","user2"] and
{table.type} = "late"
)

-LB

 

[synapsevampire]

Good idea, LB, reverse the logic, hwoever I'm still curious why it might be rewriting the code...anybody have any ideas there?

-k

 

[epoh]

lbass, I will try your not() forumla.

late and 59 are hypothetical values.