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())