TORCH Hub Query and Reporting Interfaces
Ideally we’d like to have a general interface that would let us query with virtually any term and value for specimens, specimen images, collections, and flows. So if there is a general-purpose Flask/SQLAlchemy plugin to provide a UI for querying the ORM, then that would be great. Aside from that, our main need to query and download data should be covered in the following specific examples.

Filter by:
Collection
Image types uploaded (JPG, DNG)
Each quality check (orientation, etc)
Tasks completed/not completed
Batch id?
Uploader
Upload date
Successful transfer and and sort to image repo (TACC)
Successful auto-mapping to Symbiota (once API integration is complete)

Results:
Image set (catalog number)
Image set/flow URL
Tasks/Quality checks complete/incomplete/status
Batch id
Uploader
Upload datetime
Upload IP?
Image types uploaded (JPG, DNG)
Image paths on Hub (if possible)
Successful transfer to image repo (TACC)
Transfer datetime
Transfer URL

Download results:
Download CSV
Download TSV

Other:
What is a batch? How is a batch of images defined?
How to get URL mapping file? I don’t know if this has been addressed but the query/report interface might be one way to generate the URL file needed for upload to the collection portal.