Number of tasks per dossier - Bloqs Software SQL Query - Peliqan

Number of tasks per dossier

SQL query for Bloqs Software

Count the number of tasks per dossier in the bi_dossiertaken table.

SELECT dossier_id, COUNT(*) FROM bi_dossiertaken GROUP BY dossier_id;

Bloqs Software data model

Bi Clienten

Bi Dossiertaken

Bi Facturen

Bi Intwerkregistratie

Bi Intwerkuren

Bi Medewerkers

Bi Opdr Contactpersonen

Bi Opdrachtgevers

Bi Trajecten

Bi Urenregistratie

Bi U W V Extra Info

Bi U W V Job Extra Info

Bi Verlofregistratie

Bi Verlofuren

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.