Error Message Enhancement for Missing Search Fields
TLDR Carlos encountered a "Search field not found" error and suggested including the field name in the message. Hengfei agreed and asked Carlos to create an issue.
Carlos
Tue, 27 Jun 2023 09:37:59 UTCForgot that string literals in SQL happen with `''` so changed `"999.0.0.999"` with `'999.0.0.999'` and it is fixed now
Carlos
Tue, 27 Jun 2023 09:38:54 UTCThis was the screenshot btw:
Hengfei
Tue, 27 Jun 2023 10:49:10 UTCwe will make new release soon
Carlos
Tue, 27 Jun 2023 10:50:41 UTCOh I see. As a suggestion, would it be possible to include the field name in the error? Like instead `Search field not found` -> `Search field "999.0.0.999" not found` That would help to figure out the root cause
Hengfei
Tue, 27 Jun 2023 10:52:32 UTCHa, you need use single quote for values.
Hengfei
Tue, 27 Jun 2023 10:54:35 UTCSQL has some limitations, field name can use without quote or must use double quote, field value must use single quote.
Carlos
Tue, 27 Jun 2023 10:55:46 UTCYes. That's correct. I figured out later as I explained before. I'm suggesting to change the error message to include the field name. That will help to figure out that something is wrong
Hengfei
Tue, 27 Jun 2023 10:56:41 UTCit reports by backend, but UI not report. Can you create an issue for this? we will improve UI error report.
Carlos
Tue, 27 Jun 2023 12:55:36 UTCHere we go:
OpenObserve
Indexed 419 threads
OpenObserve is an open-source, petabyte-scale observability platform for the cloud native realm, offering a 10x cost reduction and 140x less storage use compared to competitors like Elasticsearch or Splunk. Built in Rust for exceptional performance, it offers comprehensive features like logs, metrics, traces, dashboards, and more | Knowledge Base powered by Struct.AI
View in App
Carlos
Tue, 27 Jun 2023 09:08:44 UTCGetting this error when adding a second filter `Search field not found`: But it is a field that was on the available columns, and also that was already used for a count and for the X and Y columns