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

Table Projects

Table Activities

Table Clashsets

Table Groups

Table Releases

Table Shares

Table Tags

Table Todos

Table Views D

Table Viewgroups

Table Views

Table Users

Table Models

Table Model Owners

Table Model Layers

Table Model Entities

Table Model Hierarchies

Table Model History

Table Model Property Set Definitions

Magical SQL for Trimble Connect with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Total number of todos assigned to each user

SQL query for Trimble Connect

Trimble Connect data model

Magical SQL for Trimble Connect with Peliqan.io

Let AI do the work for you

Ready to get instant access to all your company data ?

Ready to get instant access to
all your company data ?