Illegal input character "$" in query builder.

[SvetoforColumb]

Bug Report

Something went wrong when I made request in query builder with $__timefilter. Time column is in INT64 type, but I transformed it into timestamp with TIMESTAMP_MICROS()

Expected Behavior

$__timefilter macro should replaced with sql

Actual Behavior

invalidQuery: No matching signature for operator BETWEEN for argument types: INT64, TIMESTAMP, TIMESTAMP. Supported signature: (ANY) BETWEEN (ANY) AND (ANY) at [7:21]
invalidQuery: Syntax error: Illegal input character "$" at [7:3]

Steps to Reproduce the Problem

1. open query editor
2. do same things as on screenshot

Specifications

• Version: v.1.0.6
• Platform: Linux
• Grafana Version: Grafana v6.3.6 (fdd2117)

[avivl]

The macro only works on time types.

[SvetoforColumb]

The macro only works on time types.

So I can't convert column with TIMESTAMP_MICROS() ?

[avivl]

No, you can't

[SvetoforColumb]

Can you say why, please? I can transform that column to time type in regular query to BigQuery. It happends because I can't use convert functions in macros?

[avivl]

I'm checking against columns that are from time types and not converted ones

[SvetoforColumb]

Can you add option to use convert functions? Technically query should work if I will convert column type to timestamp (and it works in raw query)

[avivl]

Please open a detailed feature request and I'll take a look