Skip to content

Instantly share code, notes, and snippets.

@hissy

hissy/example.sql

Created May 22, 2018 09:28
Show Gist options
  • Save hissy/490a6a19a541d813b713989e49382c53 to your computer and use it in GitHub Desktop.
Save hissy/490a6a19a541d813b713989e49382c53 to your computer and use it in GitHub Desktop.
Download ZIP
#concrete5 #mysql count how many workflow request completed between range of dates
Raw
example.sql
select count(wp.wpID)
from WorkflowProgress wp
where wp.wpIsCompleted
and wp.wpCurrentStatus = 30
and wp.wpCategoryID = 1
and wp.wfID = 2
and wp.wpDateLastAction >= "2017-05-01 00:00:00"
and wp.wpDateLastAction < "2017-06-01 00:00:00"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment