Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
...
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 |
...