filter by parsed JSON string feature - fails when value is not a string

[ryn9]

As the title says, using the filter by parsed JSON string feature...
It fails when the value is not a string (such as an integer or float number)

When a number - the generated WHERE clause should not be use JSONExtractString

[SpencerTorres]

I understand how JSONExtractString might break, but could you provide a screenshot + SQL + error message to make it easier to isolate the issue? Sounds like it's just the wrong input, but maybe we can modify the SQL to check if it's valid

[ryn9]

Given the following:

If I select "Search" for request_length, I get an error page with the following info...

Error encountered for query with inputs:

SELECT
Timestamp, ServiceNamespace, ServiceName, SeverityText, Body

ORDER BY
Timestamp DESC

WHERE
JSONExtractString (Body, 'request_length') = 1447


Error Message:
There is no supertype for types String, UInt16 because some of them are String\/FixedString\/Enum and some of them are not. 


Original Query:
SELECT
  Timestamp,
  ServiceNamespace,
  ServiceName,
  SeverityText,
  Body,
  toDateTime (Timestamp)
FROM
  MYDATABASE.TABLE
WHERE
  (
    Timestamp >= fromUnixTimestamp64Milli (1759838146000)
    AND Timestamp <= fromUnixTimestamp64Milli (1759839046000)
  )
  AND (JSONExtractString (Body, 'request_length') = 1447)
ORDER BY
  Timestamp DESC
LIMIT
  200
OFFSET
  0

NOTE: My default select is set to: "Timestamp, ServiceNamespace, ServiceName, SeverityText, Body"