Explore: Docket Detail

Docket information with document and comment counts.

Custom SQL query (hide) 

SELECT d.*, (SELECT COUNT(*) FROM comments WHERE docket_id = d.id) AS comment_count, (SELECT COUNT(*) FROM documents WHERE docket_id = d.id) AS doc_count FROM dockets d WHERE d.id = :docket_id

Query parameters

Edit SQL

0 results