Documents with most details
SQL query for Parseur
Get the documents with the highest number of document details.
SELECT documents.id, COUNT(*) AS num_details FROM documents INNER JOIN document_details ON documents.id = document_details.document_id GROUP BY documents.id ORDER BY num_details DESC LIMIT 10
Parseur data model
Documents
View 37 columns
IdInteger
NameString
ParserInteger
ResultString
StatusString
ReceivedDate-time
TemplateString
ProcessedDate-time
Attached_toString
Is_ai_readyBoolean
Credits_usedInteger
Ocr_ready_urlString
Status_sourceString
Ai_credits_usedInteger
Match_master_templateBoolean
Original_document_urlString
Ocr_page_set_0_positionInteger
Ocr_page_set_1_positionInteger
Ocr_page_set_2_positionInteger
Ocr_page_set_3_positionInteger
Ocr_page_set_0_image_urlString
Ocr_page_set_1_image_urlString
Ocr_page_set_2_image_urlString
Ocr_page_set_3_image_urlString
Conventional_credits_usedInteger
Ocr_page_set_0_image_widthInteger
Ocr_page_set_1_image_widthInteger
Ocr_page_set_2_image_widthInteger
Ocr_page_set_3_image_widthInteger
Ocr_page_set_0_image_heightInteger
Ocr_page_set_1_image_heightInteger
Ocr_page_set_2_image_heightInteger
Ocr_page_set_3_image_heightInteger
Ocr_page_set_0_image_content_typeString
Ocr_page_set_1_image_content_typeString
Ocr_page_set_2_image_content_typeString
Ocr_page_set_3_image_content_typeString
Document Details
View 20 columns
IdInteger
NameString
ParserInteger
ResultString
StatusString
ContentString
Next_idInteger
Prev_idString
ReceivedDate-time
TemplateString
ProcessedDate-time
Attached_toInteger
Is_ai_readyBoolean
Credits_usedInteger
Ocr_ready_urlString
Status_sourceString
Ai_credits_usedInteger
Match_master_templateBoolean
Original_document_urlString
Conventional_credits_usedInteger
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