DocumentationDiscussions
DocumentationDiscussions

Discussions

Ask a Question
Back to All

Query of JSON property doesn't find anything

I have a field called Data, which contains JSON data that looks like this:

[{Key: 'direction', Value: […], _typeTag: 'KeyValuePair2'}, {Key: 'username', Vale: […], _typeTag: 'KeyValuePair2'}, {Key: 'composed_at', Value: […], _typeTag: 'KeyValuePair2'}, {Key: 'message_type', Value: […], _typeTag: 'KeyValuePair2'}, {Key: 'workflow_action', Value: […], _typeTag: 'KeyValuePair2'}, {Key: 'platform_received_at', Value: […], _typeTag: 'KeyValuePair2'}, {Key: 'form_data[CurrentLocation.latitude]', Value: […], _typeTag: 'KeyValuePair2'}, {Key: 'form_data[CurrentLocation.longitude]', Value: […], _typeTag: 'KeyValuePair2'}, {Key: 'form_data[HPV-Requirement-Check]', Value: […], _typeTag: 'KeyValuePair2'}, {Key: 'form_data[ShowCustomerRules]', Value: […], _typeTag: 'KeyValuePair2'}, {Key: 'form_data[ShowHVP]', Value: […], _typeTag: 'KeyValuePair2'}, {Key: 'form_code', Value: […], _typeTag: 'KeyValuePair2'}]

It seems to me that this query should be able to find that JSON message.

SELECT Message FROM stream WHERE Message.Data.FormCode = '01'

But nothing is ever returned. My goal is to find all instances of FormCode = '01' when another field - form_data['LOAD_NUMBER'] is not present.