How to make an information link with a datetime column filtered like >= now() ?

[Yannick BRES]

How to make an information link with a datetime column filtered like >= now() ?

[David Boot-Olazabal]

Hi Yannick,

The filtering is typically handled in the WHERE clause of the SQL.

If possible, you could alter the SQL statement of the Information link directly and add this line to the WHERE clause:

SELECT *
FROM table
WHERE
datetime > getdate() (in case it's SQL Server).

You can also create a Filter object for the same, and add it to the Information Link:

Adding this filter to the Information link, will update the SQL automatically (without the need for changing it yourself):

Kind regards,

David

[Yannick BRES]

Hello,
Thank you for your answer but this is an oracle database so getdate() doesn't work. Have you another way, please ?

[Niko Maresco]

hi Yannick

in that case you want CURRENT_DATE. your query would be something like

SELECT
  A1."Column"
FROM
  "Table" A1
WHERE
  A1."TimeColumn" >= CURRENT_DATE

that should work. if you have any issues you can try these variations which should result in the same:

(SELECT CURRENT_DATE FROM DUAL)
(SELECT SYSDATE FROM DUAL)

 

[Yannick BRES]

Thanks you so much. CURRENT_DATE works.

Edited August 5 by Yannick BRES