Total number of todos assigned to each user
SQL query for Trimble Connect
Count the total number of todos assigned to each user.
SELECT u.user_name, COUNT(*) FROM users u JOIN todos t ON u.user_id = t.user_id GROUP BY u.user_name
Trimble Connect data model
Primary Folders
Models
Projects
Activities
Clashsets
Groups
Releases
Shares
Tags
Todos
Views D
Viewgroups
Views
Users
Models Selected
Model Owners
Model Layers
Model Entities Selected
Model Hierarchies
Model History
Model Property Set Definitions
Model Entities
Custom Psets
Custom Pset Defs
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed