Interval params
General
Between
Time column (chart search query and in table time column)
item_time=${params.interval}
Non time column (table search query)
item_time=BETWEEN(${interval(params.interval).begin.format()}, ${interval(params.interval).end.format()})
Floating frame 7 days
item_time=BETWEEN(${now.startOf("day").subtract(7,'days').format()}, ${now.format()})
Overlap in search query
item_start=LE(${interval(params.interval).end.format()}) item_end=GE(${interval(params.interval).begin.format()})
In case item_end can be NULL:
item_start=LE(${interval(params.interval).end.format()}) item_end=OR(GE(${interval(params.interval).begin.format()}),NULL())