Yannick BRES Posted August 1 Share Posted August 1 How to make an information link with a datetime column filtered like >= now() ? Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted August 2 Share Posted August 2 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 1 Link to comment Share on other sites More sharing options...
Yannick BRES Posted August 2 Author Share Posted August 2 Hello, Thank you for your answer but this is an oracle database so getdate() doesn't work. Have you another way, please ? Link to comment Share on other sites More sharing options...
Solution Niko Maresco Posted August 2 Solution Share Posted August 2 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) 1 Link to comment Share on other sites More sharing options...
Yannick BRES Posted August 5 Author Share Posted August 5 (edited) Thanks you so much. CURRENT_DATE works. Edited August 5 by Yannick BRES 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now