When searching JSON data using a SQL WHERE condition in the Search panel, querying array values works correctly when using array index notation, for example:
attributes.feature_manager.antiDebug[1] = 'Clean'
However, when using the following format:
attributes.feature_manager.antiDebug.0 = 'Clean'
it is treated as NULL and does not return any results.
While this behavior itself is understandable, the issue arises in the UI workflow.
When selecting a specific key-value pair from the detail view and using the Search button to add it as a SQL WHERE condition, it automatically generates the query in the following format:
attributes.feature_manager.antiDebug.0 = 'Clean'
This results in no matching data being returned, even though the equivalent array index query works correctly.
When searching JSON data using a SQL WHERE condition in the Search panel, querying array values works correctly when using array index notation, for example:
attributes.feature_manager.antiDebug[1] = 'Clean'
However, when using the following format:
attributes.
feature_manager.antiDebug.0= 'Clean'it is treated as NULL and does not return any results.
While this behavior itself is understandable, the issue arises in the UI workflow.
When selecting a specific key-value pair from the detail view and using the Search button to add it as a SQL WHERE condition, it automatically generates the query in the following format:
attributes.
feature_manager.antiDebug.0= 'Clean'This results in no matching data being returned, even though the equivalent array index query works correctly.