I know there is another post about images being displayed in a BAQ, but I didn’t see the resolution had would fit this use case. We are using a BAQ to display employee information on out intranet page with their images. I wasn’t able to find where the images are actually stored in the db. Does anyone know what table the actual images are on and how they could be display them in a BAQ(if possible)?
Thanks in advance for any help you can provide!
Employee photo/part images/etc are stored in the Ice.FileStore table.
You can’t display the images directly in a BAQ. You would have to use a Picture Box to display it in your app (there’s examples on here already, just search).
Be careful with adding the image content to a BAQ. This will slow down your queries dramatically with the amount of data being transferred over the wire. I like to fetch the image only when I select the row I want to show.
You can also use a report if you need all of the pictures shown together in a big list.
we had a webcam that used to take photos of employees for badges and we’d associate that with employee record to display on clock in and later on when iphone 11 and up started coming out… HR switched to using that for photos and thus the resolution intensified… next thing you know it took forever to clock in cause we were displaying 4K photos… so yeah, be careful with photos in BAQs/Database!
Great example!
And Backups become larger and, maybe more importantly, restores will take longer - which is undesirable in an emergency.
Great points. Thanks all!