Skip to content
This repository has been archived by the owner on Apr 21, 2021. It is now read-only.

Add support for SQL based queries : Allowing complex group by that is performed at DB layer #29

Open
StephenOTT opened this issue Nov 11, 2019 · 2 comments

Comments

@StephenOTT
Copy link
Owner

datasource = getProcessEngineConfiguration().getDataSource()

Groovy: new Sql(datasource)

@StephenOTT
Copy link
Owner Author

Query Types:

  1. Active
  2. Suspended
  3. Duration of Activity Defs Per Def Key/ID: Histo
  4. Per Tenant
  5. Per Def Key
  6. Per Def Id
  7. Per Task Type (such as Script)
  8. Assigned / Reassigned
  9. Specific Usage of Specific Delegates
  10. Process Count
  11. Process Duration (without the need for a execution listener)
  12. Msg Start Counts
  13. Timer Start Counts
  14. Number of executions per Process Instance Def/key (Histo to view parallel activity)
  15. Activity Duration Histo: Per Task Type, Per Key Per Tenant
  16. Global Variable Counts
  17. Parallel Gateway counts
  18. Multi-Instance Counts
  19. BPMN Error counts
  20. Messages Counts
  21. User Tasks
  22. Compensations
  23. Timers + Timer Defs
  24. Incidents
  25. Call Activities
  26. Messages Waiting for catch
  27. Timers Due within a Date Range (Next 15min, Next 1 day, Next 30 days, this year, etc)
  28. Boundary Timers
  29. Event Sub Processes
  30. Timers that match a specific patterns such as short timers (1min as example)

@StephenOTT
Copy link
Owner Author

Add query support to iterate over time windows to bring in older data

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant