Skip to main content

Peliqan

Try for free
Request a demo

Postman

Collections sorted by details

SQL query for Postman

List collections sorted by number of details in descending order.

SELECT c.collection_id, c.collection_name, COUNT(cd.detail_id) AS num_details FROM collections c LEFT JOIN collection_details cd ON c.collection_id = cd.collection_id GROUP BY c.collection_id ORDER BY num_details DESC

Try this query now in Postman

Postman data model

Postman
Collections

Postman
Collection Details

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