How to use current time range in url link to next dashboard

I have panel with link to detail dashboard.
I can specify time from and to in dashboard link …&from=now-2h&to=now…
How I can specify in URL params, that I want to use current time range of current dashboard from where I navigate to new dashboard?

1 Like

I also have this question. Was a solution provided?

I also have this question. Was a solution provided?

Same problem.
I did not find a solution. And yet it’s been a while since I’m looking for …

If you use a query, you can pass the values ​​$ __ timeFrom () AND $ __ timeTo () as columns in SELECT, and in the column style, put it as the hidden type and use the column link parameter {__cell_2} as an example.

Look:

SELECT [FILA_URA], count(*) AS QTDE, REPLACE(CONVERT(VARCHAR(10), __timeFrom(), 120),'-','') AS dt_ini, REPLACE(CONVERT(VARCHAR(10), __timeTo(), 120),’-’,’’) AS dt_fim
FROM YOUR_TABLE
WHERE DATA_HORA BETWEEN __timeFrom() AND __timeTo()

Link:
./d/e4Rlg6umz/filas-ura-canal?orgId=1&var-fila_ura=${__cell}&var-canal=canal&from={__cell_2}&to=${__cell_3}

With date and time:
REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(19), __timeFrom(), 120),'-',''),'T',' '),':','') AS dt_ini, REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(19), __timeTo(), 120),’-’,’’),‘T’,’ ‘),’:’,’’) AS dt_fim

2 Likes

If you want to add a time interval for your link - use time variables: &from={__from}&to={__to}.

3 Likes

Hi,

Can you explain how to define these variable ?

Thanks & Regards,
Jalpesh

1 Like

Hi.
These are predefined variables. They do not need to be defined additionally.
Here is an example of a link to another panel from a recent project:
http: //localhost:3000 / d / Nf2eNY_Wk / ProdPanel? orgId = 1 & fullscreen & panelId = 12 & from = {__from} & to = {__to}

from = {__from} & to = {__to} worked for me.

Thanks