[EPIC] query builder improvements

[srikanthccv]

• Update timeshift functions expected value precision #6657
• Parse and re-write the queries without bucket filter to include bucket filter #6594
• Open dashboard panel query in Log Explorer #6556
• Improve ClickHouse query experience #6525
• Automatic decode from Query Builder to ClickHouse Query #6472
• Allow resource., span., event., log., metric., to specify the context for WHERE clause? #6456
• UI Feedback - Stitch #6393
• Support ClickHouse query for list view #6373
• Materialized columns should also show type and datatype #6364
• Context aware cells/lines/bars across product #6338
• UI: Distinguish between attributes & resource attributes in Dashboard widget query builder #6317
• Fuzzy search for infrastructure resources #6312
• Create a formula query automatically when more than one query is enabled #6205
• Search bar auto correcting #6202
• Alternative column label for pannel type list #6195
• Support for any #6193
• ENRICHMENT: What to do when user provide wrong metadata. #6147
• What is the need of aggregation operator, aggregation attribute and group by clause in the traces tab? #6063
• Quick filtering from trace detail attributes and span events #6015
• Filtering on whole traces instead of root spans in Traces Tab in trace explorer #6013
• Full text search in traces similar to logs #6012
• Improve enrichment logic to handle type and datatype mismatches #6011
• LOGS: Full text search over all keys. #5981
• Help with promql to QB conversion #5950
• Spatial group by a field is not possible today in value panel type #5949
• Group by log pattern #5874
• Querying logs using count.distinct #5873
• Query Builder Layout Issues #5862
• [EPIC] Make the trace-explorer page more useful #5842
• The aggregation operators chosen automatically changes on changing a metric name in a panel #5818
• [EPIC] Data rendering limitations in product #5761
• Ability to download all matching logs #5701
• LOGS[BE]: Json search support for attributes #5691
• Show warning when LIKE is used without any %/_ #5681
• Non-graph panels caching support for associative aggregate operators #5657
• LOGS: Dot . not supported in key names of json search #5653
• Ability to copy where clause in the QB #5635
• Add a way to clear the QB where clause completely in a single click #5633
• Return helpful messages in case of no data #5574
• Pattern match support for metric name in builder #5488
• Automatically detect default legends based on group by clause #5485
• Ability to add OR operator in the where clause of QB #5484
• Better usability of json in logs data #5478
• Add Formula and Add Query in query builder #5397
• Keyboard compatibility #5384
• Query exceptions in the trace explorer page #5380
• Show schema of signals when using clickhouse query #5250
• Query builder user interaction improvements #5208
• result field in table panel of dashboard always named as count #5156
• QB suggestions on the last run queries #5144
• Enable plotting multiple timeseries in a chart using clickhouse query #5153
• Remove the default exists condition for group by keys? #5136
• Templates for dashboard ClickHouse query #5126
• Provide a way to link dashboard panel to different signals #5039
• Support for more types in attributes #5008
• Editing a key changes the position of the key in the QB #4984
• Improve error message shown in the UI #4978
• Link of alert page with filters applied in the triggered alerts section #4933
• Bug in fields in query builder (explorer page) when switching panels #4826
• Enable querying events with query builder #4782
• Variable suggestion in filter of query builder #4713
• Copy paste query content easily #4683
• Improve WHERE Clause search result listing #4309
• [FE] Where clause buggy on same value as suggestions #4109
• Query Builder - Text input not evaluating values on paste #3787
• Add in-product guide/help to write like, contains and regex filters in the logs QB #3786
• Unable to see aggregate options in list view of trace/logs explorer page #3660
• [EPIC] Query builder improvements #3617
• UX hints on number of 0's to put in durationNano filter #3334
• Logs explorer: wrong time aggregation interval #3289
• Allow choosing only Top Level spans when creating queries on traces data in Query Builder #3267
• Query builder breaks with percentile operator in where clause when used with limit #3204
• Filter traces with span count > x #3174
• Aggregate Options only shown after selecting Group By filter is not intuitive #3151
• show users rootSpan where one of the spans satisfies the where clause (Eg, db.system='mysql') #3085
• Allow to work with top-level service operations easily  #3043
• Prioritize fixed columns or interesting field over tag attributes #2981
• Flickering in query builder filtering #2976
• Add support for filtering on root span and service entry span #2771
• Ability to query event data from traces #2767
• Support querying exceptions data for traces #2766
• Filtering by Resource Attributes #2173
• Provide an easier and consistent experience for writing ClickHouse queries with timestamp #1743
• https://github.com/SigNoz/engineering-pod/issues/2033
• https://github.com/SigNoz/engineering-pod/issues/1954
• https://github.com/SigNoz/engineering-pod/issues/1835
• https://github.com/SigNoz/engineering-pod/issues/1709
• https://github.com/SigNoz/engineering-pod/issues/1686
• https://github.com/SigNoz/engineering-pod/issues/1667
• https://github.com/SigNoz/engineering-pod/issues/1652
• https://github.com/SigNoz/engineering-pod/issues/1511
• https://github.com/SigNoz/engineering-pod/issues/1390
• https://github.com/SigNoz/engineering-pod/issues/1228
• https://github.com/SigNoz/engineering-pod/issues/1196
• https://github.com/SigNoz/engineering-pod/issues/1192
• https://github.com/SigNoz/engineering-pod/issues/1022
• https://github.com/SigNoz/engineering-pod/issues/890
• https://github.com/SigNoz/engineering-pod/issues/836
• https://github.com/SigNoz/engineering-pod/issues/821
• Multi-Level Aggregation in QB #6697
• Count of requests with latency > X ms is not possible for histogram metric using query builder #6703