Splunk Search

How to query two nullable nested fields are not equal? [newbie question]

roliu
New Member

Hi, 

I have a dataset like below

 

 

[
  {classificationA: null, classificationB: null},
  {classificationA: {name: 'Education'}, classificationB: {name: 'Education'}},
  {classificationA: {name: 'IT'}, classificationB: {name: 'IT'}}
} 

 

 

My aim is to find all the rows whose classificationA is not equals to classificationB. So given the above dataset, it should return zero rows.

I thought it should be:

 

 

 | where classficationA != classficationB

 

 

But it is not working.  Anyone can help? Thank you!

Labels (2)
0 Karma

bowesmana
SplunkTrust
SplunkTrust

Is that your 'raw' data - it is not valid JSON. Is that a single event or 3 events?

Please share the raw data - if it's 3 classifications inside a single event, then please paste an example of the true _raw element of the value of a field that's extracted

 

0 Karma
Get Updates on the Splunk Community!

AI for AppInspect

We’re excited to announce two new updates to AppInspect designed to save you time and make the app approval ...

App Platform's 2025 Year in Review: A Year of Innovation, Growth, and Community

As we step into 2026, it’s the perfect moment to reflect on what an extraordinary year 2025 was for the Splunk ...

Operationalizing Entity Risk Score with Enterprise Security 8.3+

Overview Enterprise Security 8.3 introduces a powerful new feature called “Entity Risk Scoring” (ERS) for ...