| 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'.
Hey zacksoft,
Try this:
| base search
table amount, currency , received, time | search received = "1"
Let me know if this helps!!
Hey zacksoft,
Try this:
| base search
table amount, currency , received, time | search received = "1"
Let me know if this helps!!
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" ??
| base search
table amount, currency , received, time | search received = "1" AND currency!="dollar" AND currency!="sterling"
Please accept the answer if it worked!!
Thanks!!
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
try this
| base search
table amount, currency , received, time | search received = "1" AND (currency!="dollar" OR currency!="sterling" OR currency!="mac")
Hi @zacksoft,
try this:
|base search|where received="1"|table amount, currency , received, time
for the additional condition try this:
|base search|where received="1" AND currency!="dollar" AND currency!="sterling" |table amount, currency , received, time