How to get date time filter values in a markdown?

[vinay26]

I need to provide a hyperlink in kibana dashboard which navigates to an external site. At present,
Created a TSVB and added a markdown to define the URL.

Need to pass the selected date time range as query string to the URL defined in the markdown.

Referring to below thread:
[TSVB Visualisation get the filter date Value]

Tried fetching the date time filter from the filter control, but the auto interval time is added to the selected time in the query string.

May I please know how to fetch the exact date time range from filter control in TSVB markdown?

Attached reference screenshots.

09)

[wylie (Wylie Conlon)]

Can you be specific about what you are expecting to happen? The first screenshot you showed looks correct to me.

[vinay26]

First screenshot shows selected time:
08:59... to 09:14....

Last screenshot shows the actual time returned:
09:00:... to 09:00

Expectation is to have the same time value in last screenshot.

I have added Screenshots 2, 3, 4 to demonstrate how date time range is retrieved with aggregation.

[wylie (Wylie Conlon)]

Okay, so my first comment is that you have found a fairly hacky approach to this whole problem.

Your do not need to use params._all. Instead, use params._timestamp and params._timestamp + params._interval.

If you do this, you'll see the interval is set to 3 hours (from your screenshot). To change from 3 hours to the time range in the top right, use Kibana 7.4 or greater and choose "Entire timerange" for the time range mode.

[vinay26]

Thanks for the response. I have kibana 7.7 & used params._timestamp for start time data &
params._timestamp + params._interval for end time data.

But unable to fetch the right date time values

Selected datetime range:

Actual Result:

[wylie (Wylie Conlon)]

Sorry, it looks like the instructions I previously wrote were wrong. It seems extremely likely that the behavior you are looking for is not supported in current versions of Kibana. The good news is that we are releasing in 7.10 a feature called url drilldowns which should support this use case, but it does mean that it's not currently supported.