Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Figure 2: Select the source of data as Database SQL Query

Insert the following query into the "SQL SELECT Query" field.

...


This is an example. To implement this into your list: 1. Replace "app_fd_tablename" with your desired table name. 2. Replace dataCreated / dateModified with the desired date column. 3. Replace the aliases with custom aliases. 4. You may configure the date format (%Y-%m-%d %H:%i:%s) accordingly.
5. Insert the following query into the "SQL SELECT Query" field.
Code Block
.

SELECT 
    DATE_FORMAT(MAX(dateCreated), '%Y-%m-%d %H:%i:%s') AS max_dateCreated, 
    DATE_FORMAT(MIN(dateModified), '%Y-%m-%d %H:%i:%s') AS min_dateModified,
FROM 
    app_fd_tablename

...