All OrderId
This query gives all distinct orderID
basesearch | dedup orderID | table orderID
This query gives all distinct orderID with status=success
basesearch status=success | dedup orderID | table orderID
How do I find a table with all the failed orderID with a single nested query?
I have tried the following query
| set diff [search basesearch | dedup orderID | table orderID] [search basesearch status=sucess | dedup orderID | table orderID]
But it is not returning the failed orders.
... View more