List of all projects and their activities
SQL query for Trimble Connect
Retrieve all projects along with their associated activities.
SELECT p.project_name, a.activity_name FROM projects p JOIN activities a ON p.project_id = a.project_id
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