Skip to main content

Peliqan

Try for free
Request a demo

Parseur

Average document details

SQL query for Parseur

Get the average number of document details per document.

SELECT AVG(count) FROM (SELECT COUNT(*) AS count FROM document_details GROUP BY document_id) AS subquery

Try this query now in Parseur

Parseur data model

Parseur
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
Parseur
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