Number of notes per object
SQL query for Attio
Get the count of notes for each object in the database.
SELECT objects.name, COUNT(notes.id) as note_count FROM objects LEFT JOIN notes ON objects.id = notes.object_id GROUP BY objects.name
Attio data model
Companies
Deals
Lists
Objects
Notes
People
Tasks
Entries
Users
Workspaces
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