I have a customized dashboard on top of ODK Aggregate, which pulls the data from the default ODK database and tables. For images, I am decoding the data direct from the VALUE column of the table FormName_ImageName_BLB. However, it is tedious and puts load on server. I also noticed that there is an image filename in FormName_ImageName_BN table, in the column UNROOTED_FILE_PATH.
Does ODK save the image file as filename.jpg anywhere on the ODK server? Which directory?