Skip to main content

Peliqan

Try for free
Request a demo

Monday

Boards with most folders

SQL query for Monday

Get the top 5 boards with the most folders.

SELECT b.board_id, b.board_name, COUNT(f.folder_id) AS num_folders FROM boards b LEFT JOIN folders f ON b.board_id = f.board_id GROUP BY b.board_id, b.board_name ORDER BY num_folders DESC LIMIT 5

Try this query now in Monday

Monday data model

Monday
Boards

View 2 columns
IdString
NameString
Monday
Subitems Of Budget Test Board

View 8 columns
IdString
DateString
NameString
OwnerString
StatusString
Board_idString
Group_idString
Group_titleString
Monday
Budget Test Board

View 9 columns
IdString
DateDate-time
NameString
PersonString
StatusString
SubitemsString
Board_idString
Group_idString
Group_titleString
Monday
Subitems Of Test Board

View 8 columns
IdString
DateString
NameString
OwnerString
StatusString
Board_idString
Group_idString
Group_titleString
Monday
Test Board

View 10 columns
IdString
DateString
NameString
PersonString
StatusString
SubitemsString
Board_idString
Group_idString
Group_titleString
NikoTestColumnString
Monday
Folders

Monday
Users

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