Loading Table with as default date and Searching table with a datepicker form. #76

Activity

1. lovasoa commented on Aug 30, 2023

   

   lovasoa

   on Aug 30, 2023

   Collaborator

   More actions

   I made a small example: https://replit.com/@pimaj62145/SQLPage-Time-series-example?v=1

   let me know if it helps
2. althaf004 commented on Aug 30, 2023

   

   althaf004

   on Aug 30, 2023

   Last edited by althaf004

   Author

   More actions

   will this load the data from the db based on the date selected ? because in initial load for the todays date, even though there is value, it didn't get populated.
3. lovasoa commented on Aug 30, 2023

   

   lovasoa

   on Aug 30, 2023

   Last edited by lovasoa

   Collaborator

   More actions

   Yes, look at the code!

   SELECT 'list' AS component, 'Events' AS title;
   SELECT event_datetime AS title,
       event_description as description,
       'calendar' as icon
   FROM events
     WHERE event_datetime BETWEEN $Date AND date($Date, '+1 day');

   The code is for SQLite, you'll need to adapt the syntax if you're using a different database.
4. althaf004 commented on Aug 30, 2023

   

   althaf004

   on Aug 30, 2023

   Author

   More actions

   yes i`m using postgresql.
5. lovasoa commented on Aug 30, 2023

   

   lovasoa

   on Aug 30, 2023

   Collaborator

   More actions

   You'll have to use postgres date and time functions, then.
6. sqlpage

   locked and limited conversation to collaborators on Aug 30, 2023
7. lovasoa

   converted this issue into a discussion #78 on Aug 30, 2023