Forum Discussion
get data - load data base on date filter
Hi,
When connecting to MySQL, you can provide a custom SQL statement where you can provide this Date filter.
Alternatively, you could connect to MySQL without a SQL statement, which will let you navigate to the table in question. Once you select the table, click Edit and this will bring you into the Query Editor experience. You can define filters based on Date columns within the Query Editor without the need to learn or write SQl statements. These filters can be static dates or dynamic (i.e. This Week, This Month, Year To Date, etc.).
Thanks,
M.
Hi,
When connecting to MySQL, you can provide a custom SQL statement where you can provide this Date filter.
Alternatively, you could connect to MySQL without a SQL statement, which will let you navigate to the table in question. Once you select the table, click Edit and this will bring you into the Query Editor experience. You can define filters based on Date columns within the Query Editor without the need to learn or write SQl statements. These filters can be static dates or dynamic (i.e. This Week, This Month, Year To Date, etc.).
Thanks,
M.
