I am storing an image in my postgres database (as binarydata) but when I go to retrieve the image I am getting a 404 error. I looked at the blob in the database and it seemed wrong but I am not sure how to fix it because the upload widget handles the img data.
After many hours I finally figured out the issue, Apparently the Integration Builder is not as good as Integration Studio. I built my own database extension following this guide and the images now appear as they should.
Edit: Upon further digging I realized that when I switch a primary key to auto generate, images that pull from that table will break. So it may not necessarily be the integration builders fault.
Your code seems good, anyway is confused on screen. You don't need a new query to show form, a record on screen it's enough.
About the save is better if you use like that:
If you make a direct query to the database there is no record or you have everything less the binary?
Everything saves in the database correctly its only the image is causing me problems.
Also the image is well saved looking for your screenshot.
Try to create a new page only to show One imagem from DB. It corrupt file
I created a new page with a new aggregator to pull an image from the database and I am still having the same issue with the 404 error.
Do you solved the problem?
No I am still unsure how to solve the problem.
Good to know this about integration builder.
Thanks to let us know