don't show rows with specific column values

[zacksoft]

| base search
table amount, currency , received, time

The value of 'received' field is either 0 or 1.

I want my table to show rows where the value of column 'received' is '1'.

[deepashri_123 · Accepted solution]

Hey zacksoft,

Try this:
| base search
table amount, currency , received, time | search received = "1"

Let me know if this helps!!

[zacksoft]

This works. Thank u.
One more thing. I also want to add the condition there,
show me only the rows where "received"="1" and "currency" not equal to "dollar" or "sterling" ??

[deepashri_123]

| base search
table amount, currency , received, time | search received = "1" AND currency!="dollar" AND currency!="sterling"

Please accept the answer if it worked!!
Thanks!!

[zacksoft]

I think this won't work .It is checking here if all three conditions are true.
What I am looking for is received = "1" condition must be true AND Currency not equal to dollar OR Sterling OR Mac.

Hope I didn't confuse

[deepashri_123]

try this
| base search
table amount, currency , received, time | search received = "1" AND (currency!="dollar" OR currency!="sterling" OR currency!="mac")

[493669]

Hi @zacksoft,
try this:

|base search|where received="1"|table amount, currency , received, time

[493669]

for the additional condition try this:

|base search|where received="1" AND currency!="dollar" AND currency!="sterling" |table amount, currency , received, time