Were to use where and when to use OR when to use AND

[MeMilo09]

Hi Guys, 

I am novice somewhat, and confusion has struck.

Where does the | where clause go in the query? Is it before stats typically or after, end of query? 

Also, AND -- I understand to use this when I want for example both burger and fries -- so like I want my results to show me both burger and fries so I would query - (burger AND fries)  ---- or is this OR instead of and? When would I use OR instead ? 

Would like just some brief examples. Thanks in advance 

[gcusello · Accepted solution]

Hi @MeMilo09,

about the where command, you can find all the information at https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Where

In few words, it's usually used when you have to check the result (true or false) of an eval condition (e.g. | where value>100).

About the boolean operators, you can find more information at https://docs.splunk.com/Documentation/Splunk/8.2.0/SearchReference/UnderstandingSPLsyntax#Boolean_op...

in few words: OR must be always used, instead AND isn't mandatory in a search, but it's mandatory in the conditions (e.g. in eval command).

Put attention to the difference between NOT and != https://docs.splunk.com/Documentation/Splunk/8.2.0/Search/NOTexpressions

Ciao.

Giuseppe

[gcusello]

Hi @MeMilo09,

good for you,see next time!

Ciao and happy splunking.

Giuseppe

P.S.: Karma Points are appreciated 😉