Last 30 days Workbench / SQL

user09167

Hi Domo friends,

 

I want to query data via workbench but the backend table I'm pulling from is unnecessarily big. I want to limit the date from to the last 30 days from the current day and have it replaced every day. My inclination is something like:

 

`select * from 'data_source'  where 'day' = {!lastvalue:day!} - 30 

 

but I'm not sure what the proper syntax is. Please let me know if I need to include more information here, thanks!

Valiant

If it's just a standard SQL connection, you should be able to query the source data with something like this:

SELECT * FROM data_source
WHERE [day] >= DATEADD(day, -30, getdate())

If it's a MySQL datasource it would look more like this:

SELECT * FROM `data_source` 
WHERE `day` >= DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)

Hopefully that helps you get what you're looking for

 

Sincerely,

Valiant

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

Valiant

If it's just a standard SQL connection, you should be able to query the source data with something like this:

SELECT * FROM data_source
WHERE [day] >= DATEADD(day, -30, getdate())

If it's a MySQL datasource it would look more like this:

SELECT * FROM `data_source` 
WHERE `day` >= DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)

Hopefully that helps you get what you're looking for

 

Sincerely,

Valiant

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.